Old/New

Поиск
Список
Период
Сортировка
От Bob Pawley
Тема Old/New
Дата
Msg-id A7B0FFC861FD4380A747C656E9012E77@desktop
обсуждение исходный текст
Ответы Re: Old/New
Список pgsql-general
Hi
 
I am getting a strange result when using the following -

 Select fluid_id into fluidid
 from p_id.processes
 where new.pump1 = 'True'
 and old.pump1 = 'False'
  or old.pump1 is null;
 
The fluid_id return is fine when there is a single row. However with two rows, and updating only one of the rows, I quite often get the fluid_id for the other row.
 
I am using an After Update trigger.
 
Bob 

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