Skip site navigation (1) Skip section navigation (2)

Re: case statement to cath nulls on joined tables

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-02-04 22:07:17
Subject: Re: two questions regarding warm-standby on 8.4
Previous:From: ajay kumarDate: 2012-02-03 16:44:44
Subject: Postgres community version limitaiton - help needed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group