Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL Function Help - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/pgSQL Function Help
Date
Msg-id 28963.1134765001@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL Function Help  ("Niblett, David A" <niblettda@gru.com>)
Responses Re: PL/pgSQL Function Help
List pgsql-general
Tree view 
"Niblett, David A" <niblettda@gru.com> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.1 build on Solaris has LATIN9?
Next
From: Michael Fuhr
Date:
Subject: Re: PL/pgSQL Function Help