Re: execute in pl/pgsql

Solved:-)
Thanks for your aanswer, now I can go further with
exploring pl/pgsql. Looks nice.

Brgds

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Dino Vliet <dino_vliet(at)yahoo(dot)com> 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