[GENERAL] no syntax error on limit1

2013-10-09 Thread Willy-Bas Loos 
Hi,

Postgres 9.1.9 gives me no syntax error on this, but all the records:
with a as (values
(1),(2),(3))
select *
from a
limit1

Cheers,

WBL

-- 
Quality comes from focus and clarity of purpose -- Mark Shuttleworth

Re: [GENERAL] no syntax error on limit1

2013-10-09 Thread Szymon Guz 
On 9 October 2013 14:24, Willy-Bas Loos willy...@gmail.com wrote:

 Hi,

 Postgres 9.1.9 gives me no syntax error on this, but all the records:
 with a as (values
 (1),(2),(3))
 select *
 from a
 limit1


Hi,
that's quite OK. The limit1 is just an alias for the table a

Szymon

Re: [GENERAL] no syntax error on limit1

2013-10-09 Thread Willy-Bas Loos 
duh!
thx.


On Wed, Oct 9, 2013 at 2:30 PM, Szymon Guz mabew...@gmail.com wrote:


 On 9 October 2013 14:24, Willy-Bas Loos willy...@gmail.com wrote:

 Hi,

 Postgres 9.1.9 gives me no syntax error on this, but all the records:
 with a as (values
 (1),(2),(3))
 select *
 from a
 limit1


 Hi,
 that's quite OK. The limit1 is just an alias for the table a

 Szymon




-- 
Quality comes from focus and clarity of purpose -- Mark Shuttleworth

Re: [GENERAL] no syntax error on limit1

2013-10-09 Thread Jov 
here the limit1 is a table alias， = as limit1

jov
在 2013-10-9 下午8:27，Willy-Bas Loos willy...@gmail.com写道：

 Hi,

 Postgres 9.1.9 gives me no syntax error on this, but all the records:
 with a as (values
 (1),(2),(3))
 select *
 from a
 limit1

 Cheers,

 WBL

 --
 Quality comes from focus and clarity of purpose -- Mark Shuttleworth