From: | "Emanuel Calvo Franco" <postgres(dot)arg(at)gmail(dot)com> |
---|---|
To: | "General PostgreSQL List" <pgsql-general(at)postgresql(dot)org> |
Subject: | This is a limit-offset bug? |
Date: | 2008-12-26 11:52:59 |
Message-ID: | f205bb120812260352l64e4e338vfd5029e3626ef7ab@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Emanuel Calvo Franco | 2008-12-26 13:45:39 | Re: Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress |
Previous Message | Pavel Stehule | 2008-12-26 10:05:52 | Re: Conditional commit inside functions |