| 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: | Whole Thread | Raw Message | 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 |