no syntax error on limit1

On 9 October 2013 14:24, Willy-Bas Loos <willybas@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 <mabewlun@gmail.com> wrote:

On 9 October 2013 14:24, Willy-Bas Loos <willybas@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

here the limit1 is a table alias， = as limit1

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