Re: empty set
От
Bruno Wolff III
Тема
Re: empty set
Дата
Msg-id
20060609073356.GA522@wolff.to
Ответ на
empty set (CG)
Список
Дерево обсуждения
empty set CG <cgg007@yahoo.com>
Re: empty set Scott Marlowe <smarlowe@g2switchworks.com>
Re: empty set "Aaron Bono" <postgresql@aranya.com>
Re: empty set Bruno Wolff III <bruno@wolff.to>
Re: empty set CG <cgg007@yahoo.com>
On Thu, Jun 08, 2006 at 14:40:12 -0700, 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? Something like the following suggests you can put a subquery there that returns 0 rows. I don't think that wil work for prepared queries though; so it may not help you. bruno=> select * from test where test in (select 1 where false);test ------ (0 rows)
В списке pgsql-sql по дате отправления
