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.





Fri, 07 Mar 2003 14:25:41 +0300
Teodor Sigaev <teodor@stack.net>
SQL parser error
-*- 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

Fri, 7 Mar 2003 12:01:29 +0000
=?iso-8859-1?Q?=DE=F3rhallur_H=E1lfd=E1narson?= <tolli@tol.li>
Re: SQL parser error
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


Fri, 7 Mar 2003 13:43:48 +0000
Mike Aubury <mike@aubit.com>
Re: SQL parser error