Re: help with dynamic table name
| От | Jasbinder Singh Bali |
|---|---|
| Тема | Re: help with dynamic table name |
| Дата | |
| Msg-id | a47902760703052027q35e451e4nbaa34eefd4f8cec5@mail.gmail.com обсуждение исходный текст |
| Ответ на | help with dynamic table name ("Peter Schonefeld" <peter.schonefeld@gmail.com>) |
| Ответы |
Re: help with dynamic table name
Re: help with dynamic table name |
| Список | pgsql-novice |
try replacing double quotes with single quotes and you should be fine i think
~Jas
On 3/5/07, Peter Schonefeld <peter.schonefeld@gmail.com> wrote:
Hi, could someone please let me know what i'm doing wrong here?
CREATE OR REPLACE FUNCTION sc_insert_row(char(32),text,varchar(32)) RETURNS text AS $$
DECLARE sql text;
BEGIN
sql := "INSERT INTO "+ $3 +" ('id','body') VALUES ("+ $1 +","+ $2 +")";
EXECUTE sql;
RETURN '';
END;
$$ LANGUAGE 'plpgsql' VOLATILE;
I get the error: "ERROR: 42703: column \"INSERT INTO \" does not exist"
Cheers
Pete
В списке pgsql-novice по дате отправления: