Re: FIX : teach expression walker about RestrictInfo

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FIX : teach expression walker about RestrictInfo
Дата
Msg-id 34353.1430250604@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FIX : teach expression walker about RestrictInfo  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: FIX : teach expression walker about RestrictInfo  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> the attached trivial patch adds handling of RestrictInfo nodes into 
> expression_tree_walker().

RestrictInfo is not a general expression node and support for it has
been deliberately omitted from expression_tree_walker().  So I think
what you are proposing is a bad idea and probably a band-aid for some
other bad idea.

> This is needed for example when calling 
> pull_varnos or (or other functions using the expression walker) in 
> clausesel.c, for example. An example of a query causing errors with 
> pull_varnos is

> select * from t where (a >= 10 and a <= 20) or (b >= 15 and b <= 20);

Really?

regression=# create table t (a int, b int);
CREATE TABLE
regression=# select * from t where (a >= 10 and a <= 20) or (b >= 15 and b <= 20);a | b 
---+---
(0 rows)
        regards, tom lane



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: COPY and file_fdw with fixed column widths
Следующее
От: Tom Lane
Дата:
Сообщение: Re: cache invalidation for PL/pgsql functions