Re: PL/pgSQL Function Help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Niblett, David A" <niblettda(at)gru(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL Function Help
Date: 2005-12-16 20:30:01
Message-ID: 28963.1134765001@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

"Niblett, David A" <niblettda(at)gru(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-12-16 20:42:31 Re: PL/pgSQL Function Help
Previous Message Niblett, David A 2005-12-16 20:14:57 PL/pgSQL Function Help

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2005-12-16 20:31:01 Re: [GENERAL] Transacciones Anidadas
Previous Message Tom Lane 2005-12-16 20:28:43 Re: 8.1 build on Solaris has LATIN9?