Solved:-) Thanks for your aanswer, now I can go further with exploring pl/pgsql. Looks nice. Brgds --- Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Dino Vliet <dino_vliet@xxxxxxxxx> writes: > > In my pl/pgsql procedure I have the following > line: > > > execute 'copy cancella to ' || location || ' with > > delimiter as \',\''; > > quote_literal(location) would work much better and > more safely. > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will > ignore your desire to > choose an index scan if your joining column's > datatypes do not > match > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
