Re: Subselects open issue Nr. NEW

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SARZ
Тема Re: Subselects open issue Nr. NEW
Дата
Msg-id 219F68D65015D011A8E000006F8590C6010A51DB@sdexcsrv1.sd.spardat.at
обсуждение исходный текст
Ответ на Subselects open issue Nr. NEW  ("Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>)
Ответы Re: [HACKERS] Re: Subselects open issue Nr. NEW
Список pgsql-hackers
Gosh, please leave it in it is superb, great, fantastic ...
If somebody defines a different behavior as standard in the future,
we will need to tell him that he has a gordian knot in his brains :-)

Andreas

> I understand this. And this is how it works currently:
>
> select * from tab where (A,B) >= ANY (select X, Y from tab2);
>
> means: select tuples where A >= X _and_ B >= Y for some tuple from tab2.
>                                   ^^^^^
>          'AND' is used for all Op-s except for '<>' when 'OR' is used.
>
> Question is "should we drop this feature (?) or leave it as is ?"


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

Предыдущее
От: "Vadim B. Mikheev"
Дата:
Сообщение: Re: [HACKERS] Re: [BUGS] General Bug Report: palloc fails with lots of ANDs and ORs
Следующее
От: Zeugswetter Andreas SARZ
Дата:
Сообщение: Re: Subselects open issue Nr. NEW