From: Mulham freshcode <mulhamcode@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: select into
Date: Wed, 22 Nov 2006 00:28:15 -0800 (PST)
Message-ID: <20061122082816.26958.qmail@web90504.mail.mud.yahoo.com> (raw)
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.
Thank you,
---------------------------------
Sponsored Link
Mortgage rates near 39yr lows. $420,000 Mortgage for $1,399/mo - Calculate new house payment
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mulhamcode@yahoo.com
Subject: Re: select into
In-Reply-To: <20061122082816.26958.qmail@web90504.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox