--0016e65c7c20a41b7f04822aa832
Content-Type: text/plain; charset=UTF-8
2010/3/19 Julius Tuskenis <julius [at] nsoft.lt>
> Hello
>
> lets say I have a function add_user(user varchar(20), password
> varchar(20)). In its body I want to have statement INSERT INTO
> my_users(user, password) VALUES (user, password); The problem is I cant -
> then I try to create such function I get "ERROR: syntax error at or near
> "$1"
> LINE 1: INSERT INTO my_users( $1 .... " This tells me the parameter is
> used instead of column name. That is of course not what I wanted. What would
> you recommend to fix this? Is there any way to tell the postgres that user
> is column name? I tried "user" with same error. Must I change the names of
> parameters?
>
> using PG 8.3
>
>
You won't have to change the parameters in the function definition, instead
you can use the RENAME clause:
CREATE OR REPLACE FUNCTION add_user(user varchar(20), password varchar(20) )
RETURNS VOID AS $$
DECLARE
RENAME user TO x_user;
RENAME pa TO x_password;
BEGIN
INSERT INTO my_users(user, password) VALUES (x_user, x_password);
END; LANGUAGE plgpsql;
regards
Szymon
--0016e65c7c20a41b7f04822aa832
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div class=3D"gmail_quote">2010/3/19 Julius Tuskenis <span dir=3D"ltr"><=
<a href=3D"mailto:julius [at] nsoft.lt" target=3D"_blank">julius [at] nsoft.lt</a>>=
;</span><br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bo=
rder-left:1px #ccc solid;padding-left:1ex">
Hello<br>
<br>
lets say I have a function add_user(user varchar(20), password varchar(20))=
.. In its body I want to have statement INSERT INTO my_users(user, password)=
VALUES (user, password); The problem is I cant - then I try to create such=
function I get "ERROR: =C2=A0syntax error at or near "$1"<b=
r>
LINE 1: INSERT INTO my_users( =C2=A0$1 .... " This tells me the parame=
ter is used instead of column name. That is of course not what I wanted. Wh=
at would you recommend to fix this? Is there any way to tell the postgres t=
hat user is column name? I tried "user" with same error. Must I c=
hange the names of parameters?<br>
<br>
using PG 8.3<br>
<br></blockquote><div><br></div><div>You won't have to change the param=
eters in the function definition, instead you can use the RENAME clause:</d=
iv><div><br></div><div>CREATE OR REPLACE FUNCTION add_user(user varchar(20)=
, password varchar(20) ) RETURNS VOID AS $$</div>
<div>DECLARE</div><div>=C2=A0=C2=A0RENAME user TO x_user;=C2=A0</div><div>=
=C2=A0=C2=A0RENAME pa TO x_password;=C2=A0</div><div>BEGIN</div><div>=C2=A0=
=C2=A0INSERT INTO my_users(user, password) VALUES (x_user, x_password);</di=
v><div>END; LANGUAGE plgpsql;=C2=A0</div>
<div><br></div><div>regards</div><div>Szymon</div></div>
--0016e65c7c20a41b7f04822aa832--
