Isn't there a space missing in there ? limit10 - limit 10 All you've done is alias the tablename....
On Friday 07 March 2003 11:25 am, Teodor Sigaev wrote: > Query > select * from TABLE limit10; > returns all rows, but it seems to me this is a syntax error... > > pgsql 7.3.2 and current CVS has this bug. > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])