This is a limit-offset bug?

Поиск
Список
Период
Сортировка
От Emanuel Calvo Franco
Тема This is a limit-offset bug?
Дата
Msg-id f205bb120812260352l64e4e338vfd5029e3626ef7ab@mail.gmail.com
обсуждение исходный текст
Ответы Re: This is a limit-offset bug?
Список pgsql-general
Hi people,

Yesterday when i was making some commands on 8.3.5
(on Centos)
i found a rare behavior of limit offset.

Try in psql:

select * from foo limit 3; <- shows ok
select * from foo limit3; <- shows all rows
select * from foo offset1223raf3w4t4tgga; <- shows all rows
select * from foo limitsdfsdfaerfgsafqaweawe; <- shows all rows
select * from foo limit; <- this shows error ok
select * from foo limitt; ....

All the chars inmediatly continue the limit or offset commands
are ignored.

If this kind of problems there isn't a bug, sorry.

--
      Emanuel Calvo Franco
Syscope Postgresql Consultant
     ArPUG / AOSUG Member

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Conditional commit inside functions
Следующее
От: "Emanuel Calvo Franco"
Дата:
Сообщение: Re: Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress