Re: select into

Richard Broersma Jr <rabroersma@yahoo.com> schrieb:

> > Hi guys,
> > 
> >    Am new to sql scripting so this might be a stupid question. Am getting an error while trying
> > to do the following
> >   
> > SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;
> > 
> > where svc_data_rec is defined as record and svc_tbl_name is a varchar that holds the name of a
> > table  and sub_id is another varchar. the error message is
> > 
> >    ERROR:  syntax error at or near "$1" at character 17
> >    QUERY:  SELECT  * from  $1  where 'uid' =  $2
> >    CONTEXT:  PL/pgSQL function "foo" line 132 at select into variables
> >    LINE 1: SELECT  * from  $1  where 'uid' =  $2
> > 
> >    where am i going wrong? it seems that the variables are not being substituted with their
> > values correctly.
> 
> Notice:
> http://www.postgresql.org/docs/8.2/interactive/sql-selectinto.html
> and particularly this example:
> http://www.postgresql.org/docs/8.2/interactive/sql-selectinto.html#AEN54014
> Regards,

Richard, the plain SQL "INSERT INTO <table>" is an other thing as the
original problem...

He is in a PL/pgsql - function and he should rewrite this to use EXECUTE
... INTO


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°