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