Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] locked my keys in the car - Mailing list pgsql-sql

From Phil R Lawrence
Subject Re: [SQL] locked my keys in the car
Date
Msg-id 009401bdbf06$37fd5460$3e03b480@dummy.res.lehigh.edu
Whole thread Raw
List pgsql-sql
Tree view 
>So my next question is:
>Is there a way, using SQL, to do the math on this, i.e., to rm the
>patients who appear twice - once in the first query, once in the second?
>(God forbid we re-admit the same patient at some future date!)


Try MINUS.

SQL1
    MINUS
SQL2

yields SQL1's results minus any also found in SQL2.

pgsql-sql by date:

Previous
From: M Simms
Date:
Subject: Low level socket locking...
Next
From: All Of Us
Date:
Subject: password protection