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