"select 1 where false" does indeed indicate an empty set. I was hoping for
something more elegant, but I'll take what I can get. :)
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Thu, Jun 08, 2006 at 14:40:12 -0700,
> CG <[EMAIL PROTECTED]> wrote:
> > PostgreSQL 8.1
> >
> > I've been try
On Thu, Jun 08, 2006 at 14:40:12 -0700,
CG <[EMAIL PROTECTED]> wrote:
> PostgreSQL 8.1
>
> I've been trying to write a SQL prepare routine. One of the challenging
> elements I'm running into is an empty set ...
>
> "select foo from bar where foo in ? ;"
>
> What if "?" is an set with zero elem
That will work if foo is never NULL. If foo takes on a NULL value you will get those records where it is NULL.Is there a reason you cannot do an if/else statement on the list size? That is what I do on my queries.
-AaronOn 6/8/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Thu, 2006-06-08 at 16:
On Thu, 2006-06-08 at 16:40, CG wrote:
> PostgreSQL 8.1
>
> I've been trying to write a SQL prepare routine. One of the challenging
> elements I'm running into is an empty set ...
>
> "select foo from bar where foo in ? ;"
>
> What if "?" is an set with zero elements? What is the proper value to
PostgreSQL 8.1
I've been trying to write a SQL prepare routine. One of the challenging
elements I'm running into is an empty set ...
"select foo from bar where foo in ? ;"
What if "?" is an set with zero elements? What is the proper value to use to
replace "?" indicating an empty set?
CG
_
