From: | leaf_yxj <leaf_yxj(at)163(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | how to pass the function caller's parameter to inside the function. syntax error at or near "$1" |
Date: | 2012-03-28 16:18:16 |
Message-ID: | 1332951496887-5601045.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I want to create a function which use to truncate the table specified by the
caller. I very confused how postgresql pass this parameter into the function
:
as a superuser to execute :
1)
create or replace function d() returns void as $$
analyze;
$$ language sql;
----- this works when i issue select d()
2) this doesn't work
create or replace function v(text) returns void as $$
analyze $1;
$$ language sql;
why???? and how to correct it?
I tried another function for insert
1) this works.
create or replace function insert_f(integer) returns void as $$
insert into t1 values($1);
$$ language sql;
----this works when i issue select insert_f(20);
2) this doesn't work.
create or replace function insert_f(text,integer) returns void as $$
insert into $1 values($2);
$$ language sql;
---- it failed to create the function and give me error : syntax error at or
near "$1".
Please help.
Thanks.
Regards.
Grace
--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-pass-the-function-caller-s-parameter-to-inside-the-function-syntax-error-at-or-near-1-tp5601045p5601045.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | leaf_yxj | 2012-03-28 16:20:43 | how postgresql passes the parameter to the function. syntax error near or at "$1". |
Previous Message | Tomas Vondra | 2012-03-28 16:01:28 | Re: oracle linux |