SQL parser error
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.
-*- Teodor Sigaev <teodor@stack.net> [ 2003-03-07 11:26 ]:
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.
select*from table limit10; also works in some versions....
--
Regards,
Tolli
tolli@tol.li
Isn't there a space missing in there ?
limit10 - limit 10
All you've done is alias the tablename....
Show quoted text
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