Re: select into

Richard Broersma Jr <rabroersma(at)yahoo(dot)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°