podoc:count_subalbums_by_album_sql_function
This is an old revision of the document!
Database Function Description of "count_subalbums_by_album"
Name
count_subalbums_by_album
Description
Purpose
Schema
create function count_subalbums_by_album(integer) returns bigint as 'select count(identifier) from album where parent_album = $1' language 'sql';
create function count_subalbums_by_album(integer, integer) returns bigint as 'select count(identifier) from album where parent_album = $1 and access_rights <= $2' language 'sql';
Related tables
Related indexes
Related functions
Related views
History
Used first
Version 2.29
Used last
Still in use
Change history
= Version 2.29 =
create function count_subalbums_by_album(integer) returns bigint as 'select count(identifier) from album where parent_album = $1' language 'sql';
create function count_subalbums_by_album(integer, integer) returns bigint as 'select count(identifier) from album where parent_album = $1 and access_rights <= $2' language 'sql';
podoc/count_subalbums_by_album_sql_function.1176739673.txt.gz · Last modified: 2007/04/16 16:07 by Luud