User Tools

Site Tools


podoc:photo_shop_transaction_references_sql_function

This is an old revision of the document!


Database Function Description of "photo_shop_transaction_references"

Name

photo_shop_transaction_references

Description

Counts the number of shop transactions for a particular photo item.

Tentative (is this correct?): this represents the number of copies of a photo sold.

Purpose

To retrieve the number of shop transactions for a particular photo item.

Schema

create function photo_shop_transaction_references(integer) returns bigint
as 'select count(shop_order.transaction)
      from photo_item, shop_order
     where photo_item.photo = $1
       and photo_item.identifier=shop_order.item' language 'sql';

History

Used first

Version 2.29

Used last

Still in use

Change history

= Version 2.29 =

create function photo_shop_transaction_references(integer) returns bigint
as 'select count(shop_order.transaction)
      from photo_item, shop_order
     where photo_item.photo = $1
       and photo_item.identifier=shop_order.item' language 'sql';
podoc/photo_shop_transaction_references_sql_function.1176908303.txt.gz · Last modified: 2007/04/18 14:58 by Luud