From: Erol Oz <eroloz@bilgi.edu.tr>
To: Zot O'Connor <zot@zotconsulting.com>
Cc: postgres sql <pgsql-sql@hub.org>
Subject: Re: Finding entries not in table..differnce?
Date: Tue, 11 Jul 2000 03:50:33 +0300
Message-ID: <396A6F59.6132C357@bilgi.edu.tr> (raw)
References: <396A6A7B.39CC7772@zotconsulting.com>
If I understand you exactly, you may use except:
select distinct * from prodlang
except
select distinct * from prodlang2
gives you the records which exist in prodlang and do not exist in
prodlang2. So you get all the records in prodlang which are newly
inserted or updated.
regards
erol
Zot O'Connor wrote:
>
> I need to write a quick function that tells me all of the entriles in
> table that are not in table2.
>
> The tables are copies of each other, but 1 has been updated. I know
> this is easy, but I am running on little sleep :)
>
> I want to due something like
>
> select prodlang.prodlsku from prodland,prodlang2 WHERE prodlang.prodlsku
> != prodlang2.prodlsku
>
> But of course I would get every record, several times since at some
> point the sku does not equal another sku.
>
> I tried !!= (NOT IN) but it did not like that at all, since sku is a
> char field.
>
> I am running an older version of postgress on this server, I do not know
> if that is important.
>
> --
> Zot O'Connor
>
> http://www.ZotConsulting.com
> http://www.WhiteKnightHackers.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: eroloz@bilgi.edu.tr, zot@zotconsulting.com, pgsql-sql@hub.org
Subject: Re: Finding entries not in table..differnce?
In-Reply-To: <396A6F59.6132C357@bilgi.edu.tr>
References: <396A6A7B.39CC7772@zotconsulting.com> <396A6F59.6132C357@bilgi.edu.tr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox