Re: empty set

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.

-Aaron

On 6/8/06, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
>
> 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
> use to
> > replace "?" indicating an empty set?
>
> NULL?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>