Re: Providing an alternative result when there is no result

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