[postgis-devel] case statement to cath nulls on joined tables
chodgson at refractions.net
Thu Feb 2 18:35:34 PST 2012
This isn't really the right place for this question (perhaps the
postgresql users list?) but you'll find the syntax for the "case"
The "coalesce" function (also described on that page) also does what you
want with less words.
On 12-02-02 06:25 PM, John Morgan wrote:
> I am doing a left outer join between a polygon table and a data
> table.Everything returns fine from this join as expected.However,
> there are cases where there isn’t data for a given polygon and this
> return as the expected null in the result set.I would like to utilize
> something like a case statement to catch the nulls and return a “more
> friendly” message.I have tried unsuccessfully to use the following logic:
> /Select case value_of_interest null then ‘more friendly message’ else
> value_of_interest end/
> /From poly_table left outer join data_table one poly_table.common_id =
> If someone could let me know where I am going wrong it would be
> greatly appreciated.
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-devel