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
-*- Teodor Sigaev <[EMAIL PROTECTED]> [ 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
[EMAIL
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
