From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: olivier boissard <olivier.boissard@cerene.fr>
To: pgsql-admin@postgresql.org
Subject: Re: except command
Date: Mon, 13 Aug 2007 13:07:43 -0500
Message-ID: <46C0579F.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <46C099F6.8050002@cerene.fr>
References: <46C099F6.8050002@cerene.fr>
>>> On Mon, Aug 13, 2007 at 12:50 PM, in message <46C099F6.8050002@cerene.fr>,
olivier boissard <olivier.boissard@cerene.fr> wrote:
> I tried to use the except command in postgresql 8.1
> I don't understand as it works
> When I read doc , I understand that it was like a difference betwwen two
> queries
That isn't how I read it:
"The EXCEPT operator returns the rows that are in the first result set
but not in the second."
( http://www.postgresql.org/docs/8.1/interactive/sql-select.html )
Are you seeing something different?
This gets me all the eye color codes that don't start with the letter 'B'.
(There are of course easier ways to get that...)
bigbird=> select * from "EyeColorCode" except select * from "EyeColorCode" where "eyeColorCode" like 'B%';
eyeColorCode | descr | isActive | dotEyeColorCode
--------------+-----------------+----------+-----------------
GRN | Green | t | GRN
GRY | Gray | t | GRY
HAZ | Hazel | t | HAZ
MAR | Maroon | t | MAR
MUL | Multicolored | t | DIC
PNK | Pink | t | PNK
XXX | Unknown | t | UNK
(7 rows)
-Kevin
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, olivier.boissard@cerene.fr
Subject: Re: except command
In-Reply-To: <46C0579F.EE98.0025.0@wicourts.gov>
* 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