----- "Christine Penner" <christine@xxxxxxxxxxxxxxxxxxxxx> wrote: > Hi, > > I'm trying to create a simple function but having a bit of trouble. > This is what I want to do. > > I want to pass a key as a parameter (BKEY integer) > the code in the function should be > count(*) from F_BUILDINGS where B_PRIMARY_SEQ=BKEY > > I want to return the count from the select statement. > > Christine Penner > Ingenious Software > 250-352-9495 > <mailto:christine@xxxxxxxxxxxxxxxxxxxxx>christine@xxxxxxxxxxxxxxxxxxxxx > Something along lines of: CREATE OR REPLACE FUNCTION public.count_test(integer) RETURNS bigint LANGUAGE sql AS $function$ select count(*) from F_BUILDINGS where B_PRIMARY_SEQ=$1; $function$ Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
