Re: Re: Does PostgreSQL support EXISTS?

From: KuroiNeko <evpopkov(at)carrier(dot)kiev(dot)ua>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Does PostgreSQL support EXISTS?
Date: 2001-06-13 04:28:47
Message-ID: 3B26EBFF.nailMJ1D8AHP@ed.ed
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

--

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Dunn 2001-06-13 06:21:26 Re: PLPGSQL: Using SELECT INTO and EXECUTE
Previous Message Zak McGregor 2001-06-13 02:56:57 Re: OIDS in views