Re: A and C not B

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>, "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: A and C not B
Date: 2002-09-11 22:51:29
Message-ID: 011f01c259e5$c89cfe70$32021aac@chad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

----- Original Message -----
From: Reshat Sabiq
To: Chad Thompson
Sent: Wednesday, September 11, 2002 4:45 PM
Subject: Re: [NOVICE] A and C not B

select * from x where y in('A', 'B');

Thats not quite what i want. Finding A and B are easy as they are in the table. Finding C is easy because it is not. But if i want one list of B and C, thats a little harder. Meaning B which is listed in the table as type B, and C which is not in the table at all.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Chad Thompson 2002-09-11 22:55:51 Re: A and C not B
Previous Message Curtis Mortensen 2002-09-11 21:51:51 Re: pg_restore error