Re: BUG #9227: Error on SELECT ROW OVERLAPS ROW with single ROW argument

Поиск
Список
Период
Сортировка
От Joshua Yanovski
Тема Re: BUG #9227: Error on SELECT ROW OVERLAPS ROW with single ROW argument
Дата
Msg-id CABz-M-Hs7eGjvQQ_jPx4=7yrkg8-u2q79EBUpydGXhTznvMqzw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #9227: Error on SELECT ROW OVERLAPS ROW with single ROW argument  (Joshua Yanovski <pythonesque@gmail.com>)
Ответы Re: BUG #9227: Error on SELECT ROW OVERLAPS ROW with single ROW argument  (Joshua Yanovski <pythonesque@gmail.com>)
Список pgsql-bugs
On Mon, Feb 17, 2014 at 5:07 PM, Joshua Yanovski <pythonesque@gmail.com> wrote:
> On Mon, Feb 17, 2014 at 4:33 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> While it would be a reasonably simple change to make this work as
>> originally intended, I'm strongly tempted to just rip it out instead,
>> and only support the SQL-mandated syntax.  If anyone was using this
>> undocumented feature, you'd think they'd have complained sometime in
>> the last ten years.  And making it work would really entail adding
>> documentation and a regression test case, so it'd be substantially
>> more effort than just killing the "list_length == 1" case.
>>
>>                         regards, tom lane
>
> For what it's worth, that seems reasonable to me as well.  I would
> never have found this if I weren't actually looking through gram.y
> anyway.
>
> --
> Josh

Attaching a patch to just remove the n == 1 case.

--
Josh

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: No optimization with a partition window in a view
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: No optimization with a partition window in a view