This is a limit-offset bug? - Mailing list 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