Re: empty set - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: empty set
Date
Msg-id 1149802941.25526.279.camel@state.g2switchworks.com
Whole thread Raw
In response to empty set  (CG <cgg007@yahoo.com>)
Responses Re: empty set
List pgsql-sql
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?


pgsql-sql by date:

Previous
From: CG
Date:
Subject: empty set
Next
From: "Jim C. Nasby"
Date:
Subject: Re: pgxml & xpath_table