here the limit1 is a table alias， = as limit1
jov
在 2013-10-9 下午8:27，"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 clar
duh!
thx.
On Wed, Oct 9, 2013 at 2:30 PM, Szymon Guz wrote:
>
> On 9 October 2013 14:24, Willy-Bas Loos 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
On 9 October 2013 14:24, Willy-Bas Loos 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
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
