Re: execute in pl/pgsql - Mailing list pgsql-general

From Dino Vliet
Subject Re: execute in pl/pgsql
Date
Msg-id 20060910190041.54804.qmail@web51115.mail.yahoo.com
Whole thread Raw
In response to Re: execute in pl/pgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Solved:-)
Thanks for your aanswer, now I can go further with
exploring pl/pgsql. Looks nice.

Brgds


--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Dino Vliet <dino_vliet@yahoo.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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_dump and cluster
Next
From: Richard Broersma Jr
Date:
Subject: Re: Database design and triggers...