Postgres Pro
Downloads
Home   >   mailing lists

Re: no syntax error on limit1 - Mailing list pgsql-general

From Szymon Guz
Subject Re: no syntax error on limit1
Date
Msg-id CAFjNrYtuS=ovNQ7A+gF6vzJLV_VkyC_9UNAwxb6+aXmuUq3ApA@mail.gmail.com
Whole thread Raw
In response to no syntax error on limit1  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: no syntax error on limit1  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
Tree view

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 

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: no syntax error on limit1
Next
From: Willy-Bas Loos
Date:
Subject: Re: no syntax error on limit1