Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Finding missing records... - Mailing list pgsql-sql

From Sevo Stille
Subject Re: [SQL] Finding missing records...
Date
Msg-id 38B6B00A.69D7F220@ip23.net
Whole thread Raw
In response to Finding missing records...  (Matthew Hagerty <matthew@venux.net>)
List pgsql-sql
Tree view 
Matthew Hagerty wrote:
> happened.  Can someone demonstrate a query that would show all records in
> the primary table that do not have associated records in the secondary table?

EXCEPT. As in "select key from table1 except select key_ref from
table2;". 

Sevo


-- 
sevo@ip23.net

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] how to create index on timestamp field in pre v7 database
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] how to create index on timestamp field in pre v7 database