On Tue, May 19, 2009 at 7:00 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Merlin Moncure <mmonc...@gmail.com> writes: >> On Mon, May 18, 2009 at 3:13 PM, Joshua Berry <yob...@gmail.com> wrote: >>> Is there an easy and efficient way to return a boolean false for a query >>> that returns no result, and true for one that does return a result? > >> Probably the best general approach is to: > >> select count(*) = 1 from >> ( >> <query> limit 1 >> )q; > > Seems like EXISTS() is much more straightforward ...
yes...I didn't notice david's response upthread. that is indeed very elegant. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
