Postgres Pro
Downloads
Home   >   mailing lists

Re: help with dynamic table name - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: help with dynamic table name
Date
Msg-id 20070306061908.GA57364@winnie.fuhr.org
Whole thread Raw
In response to Re: help with dynamic table name  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
On Mon, Mar 05, 2007 at 11:48:49PM -0500, Tom Lane wrote:
> but in this particular case there's no point in double-quoting those
> target-column names; it'd be the same to write
>
>   sql := 'INSERT INTO '+ $3 +' (id,body) VALUES ('+ $1 +','+ $2 +')';

And shouldn't the + operators be || ?  I'm not seeing + defined for
any character types.

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: help with dynamic table name
Next
From: "Lukas"
Date:
Subject: Pg_dump and bytaA