This is a limit-offset bug?

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

Responses

Browse pgsql-general by date

  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