View Single Post

   
  #2 (permalink)  
Old 04-15-2008, 11:28 PM
Merlin Moncure
 
Posts: n/a
Default Re: Proposal: PL/pgSQL EXECUTE INTO USING (for 8.4)

On 10/16/07, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Hello,
>
> this proposal change older unaccepted proposal
> http://archives.postgresql.org/pgsql...3/msg01157.php .
>


> Compliance with PL/SQL
> * You can use numeric, character, and string literals as bind arguments
> * You cannot use bind arguments to pass the names of schema objects to
> a dynamic SQL statement.


does this mean you can't dynamically sub in a variable for a table
name? if so, why keep that limitation? one of the main reasons to use
dynamic sql is for schema objects.

merlin

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote