Okay, If I'm going to modify 'COPY INTO' to include 'ignore duplicates' functionality it looks like I'll have to add to the COPY syntax. The most obvious way is to add:
WITH IGNORE DUPLICATES to the syntax. I'm going to need my hand held a bit for this! The grammar for COPY will need updating in gram.y and specifically the 'WITH' keyword will have 'IGNORE DUPLICATES' as well as 'NULL AS'. Any pointers? Thanks, Lee. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly