> > [EMAIL PROTECTED] writes: > streetname_lookup > (for every street name used in the country) > streetid | name | type > ----------+--------+------ > 1 | Main | St > 2 | 1st | St > Afa I'm concerned, I would add the column "city_id" since 2 different streets in 2 different cities may have the same name.
Amicalement
Patrick
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
