Pl Pgsql problem

Поиск
Список
Период
Сортировка
От lihao
Тема Pl Pgsql problem
Дата
Msg-id 001101c30d66$b00356e0$f301a8c0@pc66
обсуждение исходный текст
Ответы Re: Pl Pgsql problem
Список pgsql-sql

Hi,

 

I am using 7.1.3 on RedHat Linux 7.2.

 

I try to create a trigger on the table, I wrote a function in plpgsql, which always fail on this sql command:

 

select (''UPD'' || int2hex(nextval(''updid''), 8)) as v_updid;

 

The function is like this:

 

begin

            select (''UPD'' || int2hex(nextval(''updid''), 8)) as v_updid;

            if not found then

                 raise exception ''Unable to get updid.'';

            end if;

        end;

 

It give me this error when I trigger the function:

 

NOTICE:  Error occurred while executing PL/pgSQL function pg_fct_bf_ins_inf_article

NOTICE:  line 9 at SQL statement   -- the SQL select command

ERROR:  parser: parse error at or near "$1"

 

I can execute the SQL without problem.

<<

select ('UPD' || int2hex(nextval('updid'), 8)) as v_updid;

>>

 

Can anyone help me to see what is the problem here.

 

Li Hao

 

В списке pgsql-sql по дате отправления: