Re: Re: Does PostgreSQL support EXISTS? - Mailing list pgsql-general

From KuroiNeko
Subject Re: Re: Does PostgreSQL support EXISTS?
Date
Msg-id 3B26EBFF.nailMJ1D8AHP@ed.ed
Whole thread Raw
In response to Re: Does PostgreSQL support EXISTS?  (Nils Zonneveld <nils@mbit.nl>)
List pgsql-general
> Yes 'exists'  works (though I never understood the  advantage to the 'in'
operator).

 Each  has its  advantages and  weak points.  Eg, in  some DBMS,  number of
entries of `in ( A1, ... AN )' has a pretty tight limit. Also, in PGSQL 7.0
having even fewer  entries may cause `Tuple too big'  error. Solution is to
replace explicit enumeration with comparisons. And so on.
 `exists'  is more  `relational pure'  on one  hand, but  is probably  more
resource consuming.


--

 ������������������


pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Re: OIDS in views
Next
From: Michael Dunn
Date:
Subject: Re: PLPGSQL: Using SELECT INTO and EXECUTE