Re: Default value if query returns 0 rows? - Mailing list pgsql-general

> Thanks for the suggestion.  I've come up with the following that appears to
> work:
>
>   SELECT
>     COALESCE((SELECT id FROM map WHERE name = $1), -1)
>     FROM map_level
>     LIMIT 1

And in fact I see that this should simply be:

  SELECT COALESCE((SELECT id FROM map WHERE name = $1), -1)

No need for me to be making things all complicated.

Thanks again!

-- Lars

--
Lars Kellogg-Stedman <lars@deas.harvard.edu>
IT Operations Manager
Division of Engineering and Applied Sciences
Harvard University