This is a limit-offset bug?

Поиск
Список
Период
Сортировка
Искать
От
Emanuel Calvo Franco
Тема
This is a limit-offset bug?
Дата
Msg-id
f205bb120812260352l64e4e338vfd5029e3626ef7ab@mail.gmail.com
Список
Дерево обсуждения
This is a limit-offset bug? "Emanuel Calvo Franco" <postgres.arg@gmail.com>
Re: This is a limit-offset bug? Martijn van Oosterhout <kleptog@svana.org>
Re: This is a limit-offset bug? "Emanuel Calvo Franco" <postgres.arg@gmail.com>
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
Дата:
От: Emanuel Calvo Franco
Дата:
FAQ