w)
Thanks Tom!
--
David
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, December 16, 2005 3:30 PM
To: Niblett, David A
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PL/pgSQL Function Help
"Niblett, David A" <[EMAIL PROTECTED]&g
On Fri, Dec 16, 2005 at 03:30:01PM -0500, Tom Lane wrote:
> "Niblett, David A" <[EMAIL PROTECTED]> writes:
> > Is there no way in Postgres that I can simply not return
> > anything so I show zero rows?
>
> Make the function return SETOF myrec not just myrec. Then you
> can return zero or one (or
"Niblett, David A" <[EMAIL PROTECTED]> writes:
> Is there no way in Postgres that I can simply not return
> anything so I show zero rows?
Make the function return SETOF myrec not just myrec. Then you
can return zero or one (or more) myrec's.
regards, tom lane
---
I've got an issue with a plpgsql function and I have not
been able to find any reference to this situation in searching.
I hope that someone can point me in the correct direction.
I'm running v8.0.3 and assuming a test set up of:
-
CREATE TYPE myrec AS (
id int
);
