PostgreSQL

From: "Horaci Cuevas" <hcuevas(at)perti(dot)com>
To: <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: PostgreSQL
Date: 1999-11-26 15:49:55
Message-ID: NABBJFCKFCOHFBNGLGHOAEGDCDAA.hcuevas@perti.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I'm using PostgreSQL for a search-web based database, and i saw a missing
function mostly found in DB2 and others, where, you can get results from
a query having a WHERE condition to exist or not in another SQL sentence .

In DB2 is:

SELECT field1, field2 FROM tab1 WHERE field1 IN ( select field3 from tab2 )
or
SELECT field1, field2 FROM tab1 where field1 NOT IN ( select field3 from tab2 )

PostgreSQL already has that, but only allows to return 1 result, ex:

SELECT field1, field2 FROM tab1 where field1 =
( select field 3 from tab2 where id=1 )

Would be great if that where added to the TODO as a future Feature.

Thanks in Advance.
Horaci Cuevas.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 1999-11-26 16:13:44 Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Previous Message J. Roeleveld 1999-11-26 14:34:30 Stuck while attempting to automate User adding to existing groups...