Solved:-) Thanks for your aanswer, now I can go further with exploring pl/pgsql. Looks nice.
Brgds --- Tom Lane <[EMAIL PROTECTED]> wrote: > Dino Vliet <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
