Re: PL/pgSQL evaluation order

Поиск
Список
Период
Сортировка
От Mark Volpe
Тема Re: PL/pgSQL evaluation order
Дата
Msg-id 3989E9A4.DE98D574@epamail.epa.gov
обсуждение исходный текст
Ответ на PL/pgSQL evaluation order  (Mark Volpe <volpe.mark@epamail.epa.gov>)
Список pgsql-sql
Doesn't seem like a bad idea. I did find a better workaround, though -

cond:=TG_OP=''INSERT'';
IF cond=FALSE THENcond:=NEW.ip!=OLD.ip;
END IF;
IF cond=TRUE ...

so it won't kill me. Anyway, I've been totally impressed with the 7.0 release.
I'm building the EPA IP address registration system on top of it. My favorite
feature is the support for REFERENCES (though I had to hack the code a bit to
get around a permissions problem).

Thanks,
Mark

Jan Wieck wrote:
> 
>     Maybe we should change the treatment  of  unassigned  rowtype
>     values that any reference to it holds the NULL value?
>


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: A question about indexes...
Следующее
От:
Дата:
Сообщение: Recursive SQL