PL problem
От | Adriaan Joubert |
---|---|
Тема | PL problem |
Дата | |
Msg-id | 3764B10F.40EFD12C@albourne.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] PL problem
|
Список | pgsql-general |
Hi, Another problem with PL (I got no replies to the bug report last Friday about problems with PL when using FOR UPDATE OF ..). I think the following may be impossible fomr PL, but I store information in different tables depending on the type of job that is being handled. On reset I want to clear these tables, so i store the names of the tables in a separate table and have a loop in PL FOR table IN SELECT jb_name FROM jobparams p, jobs j WHERE jb_type = type AND j.job = tsk.job LOOP DELETE FROM table.jb_name WHERE job = tsk.job AND id = vid AND date >= tsk.fromdate AND date <= tsk.uptodate; END LOOP; and PL does not like a variable in the table name. ERROR: parser: parse error at or near "$1" I guess this may have to do with the way the query plan is stored, so that this may just be impossible to fix. Could somebody who knows how PL works please confirm whether I'm asking something impossible here? Adriaan
В списке pgsql-general по дате отправления: