Обсуждение: 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....


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