On Mon, May 18, 2009 at 3:13 PM, Joshua Berry <yob...@gmail.com> wrote: > Any hints/tips? Is our original solution okay, or is there something we can > do to improve things?
It seems as if you don't really care about the results of the query- just whether or not it returns any rows. In that case, why not something like: select (case when exists (select * from foo where...) then true else false end) as result; -- - David T. Wilson david.t.wil...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
