From: | jdmorgan <jdmorgan(at)unca(dot)edu> |
---|---|
To: | Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: case statement to cath nulls on joined tables |
Date: | 2012-02-03 18:34:53 |
Message-ID: | 4F2C28CD.5010809@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks Matheus. The coalesce method worked like a champ.
Cheers,
Derek
On 2/3/2012 10:09 AM, Matheus de Oliveira wrote:
> Even better:
>
> SELECT COALESCE(value_of_interest, 'more friendly message')
> value_of_interest
> From poly_table left outer join data_table one poly_table.common_id =
> data_table.common_id
>
> --
> Matheus de Oliveira
>
>
>
>
> On Fri, Feb 3, 2012 at 1:05 PM, Matheus de Oliveira
> <matioli(dot)matheus(at)gmail(dot)com <mailto:matioli(dot)matheus(at)gmail(dot)com>> wrote:
>
> Try that:
>
> SELECT address, CASE WHEN value_of_interest IS NULL THEN 'more
> friendly message' ELSE value_of_interest END value_of_interest
>
> From poly_table left outer join data_table one
> poly_table.common_id = data_table.common_id
>
>
> --
> Matheus de Oliveira
>
>
>
>
>
> On Fri, Feb 3, 2012 at 10:45 AM, John Morgan <jdmorgan(at)unca(dot)edu
> <mailto:jdmorgan(at)unca(dot)edu>> wrote:
>
> Hello,
>
> 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 =
> data_table.common_id*
>
> If someone could let me know where I am going wrong it would
> be greatly
> appreciated.
>
> Cheers,
>
> Derek
>
>
>
--
Derek @ NEMAC
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-02-04 22:07:17 | Re: two questions regarding warm-standby on 8.4 |
Previous Message | ajay kumar | 2012-02-03 16:44:44 | Postgres community version limitaiton - help needed |