User Tools

Site Tools


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';

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