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

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 (view raw, whole thread or download thread mbox)
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

pgsql-novice by date

Next:From: Chad ThompsonDate: 2002-09-11 22:55:51
Subject: Re: A and C not B
Previous:From: Curtis MortensenDate: 2002-09-11 21:51:51
Subject: Re: pg_restore error

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