Novice needs help

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Novice needs help
Date: 2003-03-11 17:47:37
Message-ID: 3E6E2139.5060903@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have loaded over 29,000 customer records into a database. I'm trying
to apply a referential foreign key that validates the country code and
the province code in another table. It won't work because somewhere in
that 29,000 records there is a province code or country code that
doesn't match. Is there a way to use a select statement to find out
which customer records has the invalid data? Here is the partial table
layout:

cust province
-------- -------
country ===> country
province ===> code

Thanks in advance...

--
Terry Lee Tucker

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Delorme 2003-03-11 19:39:10 The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
Previous Message Andreas Pflug 2003-03-11 15:36:12 Re: How to notice column changes in trigger