Postgres Pro
Downloads
Home   >   mailing lists

RE: SQL - Mailing list pgsql-general

From Nick Fankhauser
Subject RE: SQL
Date
Msg-id NEBBLAAHGLEEPCGOBHDGIENDCEAA.nickf@ontko.com
Whole thread Raw
In response to SQL  (Randy Jonasz <rjonasz@click2net.com>)
Responses RE: SQL  (Randy Jonasz <rjonasz@click2net.com>)
List pgsql-general
Tree view 
how about:

SELECT banid FROM a WHERE flags NOT LIKE '%v%' AND banid NOT IN (SELECT
banid FROM b);

-Nick

----------------------------------------------------------------------------
-----
Nick Fankhauser

Business: nickf@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
          Ray Ontko & Co.   Software Consulting Services
http://www.ontko.com/

Personal: nickf@infocom.com http://www.infocom.com/~nickf

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Probleme on ALTER
Next
From: Randy Jonasz
Date:
Subject: RE: SQL