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
optional.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
