Simple function - Mailing list pgsql-general

From Christine Penner
Subject Simple function
Date
Msg-id 19740415045640.C920234767BE8688@edmwaa02.telusplanet.net
Whole thread Raw
Responses Re: Simple function  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-general
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@ingenioussoftware.com>christine@ingenioussoftware.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: reindex
Next
From: Adrian Klaver
Date:
Subject: Re: Simple function