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
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 |