Hi, I am migrating data from one data structure to another and having problems writing a correct INSERT INTO blah SELECT ... from existing tables I have contact, my addresses (each contact can have several addresses) and address (each address can have several contacts). I am getting unique key address_id errors despite using a DISTINCT ON clause in my SELECT so I am doing something wrong Please slap me around the head to set my ideas straight again =:-D Tony ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org