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@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
