| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: What is Pick anyway?
B Faux wrote:
> [snip]
>> I'll define the POSTAL file with POSTALID as field 0, the key, CITY
>> as field 1 and STATE as field 2.
[snip]
Don, this only works when each POSTAL code serves only one CITY.
That's certainly not the case here in the States (assuming the POSTALID is a ZIP code; are you living somewhere else, or just making a simplifying assumption?
I thought you might be talking about ZIP+4, which doesn't (to my knowledge)
have this problem, but then you write:
> Then using the postal code, it reads
> the POSTAL file using 45678 as the key to get the city and state...
-- frostyReceived on Mon Jan 16 2006 - 14:40:20 CST
![]() |
![]() |