Re: FETCH FIRST clause PERCENT option

Поиск
Список
Период
Сортировка
От Surafel Temesgen
Тема Re: FETCH FIRST clause PERCENT option
Дата
Msg-id CALAY4q93HE3TLdewGcD=SYEsfiHvgMgecN-Cr1sgKBv4CRU6Qg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FETCH FIRST clause PERCENT option  (Erik Rijkers <er@xs4all.nl>)
Ответы Re: FETCH FIRST clause PERCENT option  (Erik Rijkers <er@xs4all.nl>)
Список pgsql-hackers

Hi Erik
On Mon, Aug 19, 2019 at 10:47 AM Erik Rijkers <er@xs4all.nl> wrote:
Hi,

(running with those two patches applied)

   select * from onek where thousand < 5 order by thousand fetch first -1
percent rows only
is correctly caught (with "ERROR:  PERCENT must not be negative") but:

   select * from  onek where thousand < 5 order by thousand fetch first
101 percent rows only
is not. It doesn't return, and cannot be Ctrl-C'ed out of, which I guess
is another bug?

Fixed

regards
Surafel
Вложения

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

Предыдущее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: Global temporary tables
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: [HACKERS] WAL logging problem in 9.4.3?