On Fri, Dec 26, 2008 at 09:52:59AM -0200, Emanuel Calvo Franco wrote:
> 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; ....
At a wild gues, if the string after the table name is a single token it
gets interpreted as an alias for the table. Remember that AS is
Have a nice day,
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
In response to
pgsql-general by date
|Next:||From: Emanuel Calvo Franco||Date: 2008-12-26 17:17:41|
|Subject: Re: This is a limit-offset bug?|
|Previous:||From: Pavel Stehule||Date: 2008-12-26 15:23:52|
|Subject: Re: count (DISTINCT expression [ , ... ] ) and documentation|