At 12:20 PM 8/15/2008, [EMAIL PROTECTED] wrote:
Date: Fri, 15 Aug 2008 13:46:14 -0400
From: "Edward W. Rouse" <[EMAIL PROTECTED]>
To:
Subject: Re: Join question
Message-ID: <[EMAIL PROTECTED]>
I did try that, but I can't get both the values from table a with no
entries
in table b and the value
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
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Richard Broers
On Fri, Aug 15, 2008 at 9:48 AM, Edward W. Rouse <[EMAIL PROTECTED]> wrote:
> The problem is I also have to include
> items from table b with that have a null user. There are some other criteria
> as well that are simple where clause filters. So as an example:
instead of left join try FULL OUTER
Sigh, I messed up the tables a bit when I typed the example, org A was
supposed to have entries for all 3 users in table a just like org B does,
not just the one. Sorry for the confusion.
Edward W. Rouse
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Edward W. Rouse
Sent:
I have 2 tables, both have a user column. I am currently using a left join
from table a to table b because I need to show all users from table a even
those not having an entry in table b. The problem is I also have to include
items from table b with that have a null user. There are some other crite
select *
from test
where test.col not in ARRAY['val1', 'val2'];
select * from test where test.col <> ALL ( ARRAY['val1', 'val2'] );
see http://www.postgresql.org/docs/current/static/functions-comparisons.html
be careful with NULLs in this type of comparisons.
Thanks a lot for all your in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi everybody,
I was reading the mails concerning the subject "Check a column value not in
Array" and
made a quick test. This is the test table:
test=# select * from values;
id |
item
- +-
1 | a