> 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 Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
