----- "Christine Penner" <christ...@ingenioussoftware.com> 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:christ...@ingenioussoftware.com>christ...@ingenioussoftware.com
>
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
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
