Thread: SQL parser error

SQL parser error

From

Teodor Sigaev

Date:

07 March 2003, 09:25:44

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.

Re: SQL parser error

From

Þórhallur Hálfdánarson

Date:

07 March 2003, 10:01:45

-*- 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

Re: SQL parser error

From

Mike Aubury

Date:

07 March 2003, 10:02:59

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