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

Re: Join question

From: Steve Midgley <public(at)misuse(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Join question
Date: 2008-08-15 21:34:48
Message-ID: 20080816032805.4687464FCEF@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-sql
At 12:20 PM 8/15/2008, pgsql-sql-owner(at)postgresql(dot)org wrote:
>Date: Fri, 15 Aug 2008 13:46:14 -0400
>From: "Edward W. Rouse" <erouse(at)comsquared(dot)com>
>To: <pgsql-sql(at)postgresql(dot)org>
>Subject: Re: Join question
>Message-ID: <04da01c8fefe$d01f9c60$705ed520$(at)com>
>
>I did try that, but I can't get both the values from table a with no 
>entries
>in table b and the values from table b with null entries to show up. 
>It's
>either one or the other.
>
>Edward W. Rouse

Might have luck with applying some additional WHERE clause criteria to 
your full outer join. So if you don't want certain types NULL's in 
table b, restrict against that in WHERE clause? I could be 
misunderstanding the whole thing though..

Steve


pgsql-sql by date

Next:From: Xavier BermeoDate: 2008-08-16 17:53:48
Subject: Cursor
Previous:From: Edward W. RouseDate: 2008-08-15 17:46:14
Subject: Re: Join question

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