Rob Northcott wrote
> Is there a nice way of forcing a default result somehow?
The Coalesce function is your friend:
SELECT COALESCE( (SELECT subquery), <default> )
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-return-a-default-value-if-no-result-tp5815850p5815860.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.