On Tuesday 16 December 2003 10:12, C G wrote:
> Thanks for your help but I still have a small problem. I'm try to do as you
> suggested and use prepare/execute but I'm doing something silly.
>
> I'm using:
>
> PREPARE my_prep1(name) AS SET SESSION AUTHORIZATION $1;
>
> and get the error message:
>
Thanks for your help but I still have a small problem. I'm try to do as you
suggested and use prepare/execute but I'm doing something silly.
I'm using:
PREPARE my_prep1(name) AS SET SESSION AUTHORIZATION $1;
and get the error message:
ERROR: syntax error at or near "set" at character 27
I have
"C G" <[EMAIL PROTECTED]> writes:
> SET SESSION AUTHORIZATION username;
> ERROR: syntax error at or near "$1" at character 28
You'll need to use EXECUTE to do this. Utility statements in general
aren't prepared to deal with parameters.
regards, tom lane
-
Dear All,
I have a simple table
CREATE TABLE table1{
user name,
si numeric
};
Also I have function:
CREATE FUNCTION check1(numeric) RETURN text AS'
DECLARE
SI ALIAS AS $1;
username name;
BEGIN
username:=(SELECT user FROM table1 WHERE si=SI)
SET SESSION AUTHORIZATION username;
RETURN username;
END;
