Re: Providing an alternative result when there is no result - Mailing list pgsql-general

From David Wilson
Subject Re: Providing an alternative result when there is no result
Date
Msg-id e7f9235d0905181238l631f3793o8f69df5075f790dc@mail.gmail.com
Whole thread Raw
In response to Providing an alternative result when there is no result  (Joshua Berry <yoberi@gmail.com>)
List pgsql-general
On Mon, May 18, 2009 at 3:13 PM, Joshua Berry <yoberi@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.wilson@gmail.com

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Providing an alternative result when there is no result
Next
From: Reece Hart
Date:
Subject: Re: Providing an alternative result when there is no result