empty set - Mailing list pgsql-sql

From CG
Subject empty set
Date
Msg-id 20060608214012.96518.qmail@web37907.mail.mud.yahoo.com
Whole thread Raw
Responses Re: empty set
Re: empty set
List pgsql-sql
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

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


pgsql-sql by date:

Previous
From: Dias Costa
Date:
Subject: Re: Query to return modified results at runtime?
Next
From: Scott Marlowe
Date:
Subject: Re: empty set