Postgres Pro
Downloads
Home   >   mailing lists

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

From Willy-Bas Loos
Subject Re: no syntax error on limit1
Date
Msg-id CAHnozTivJywMujOphHov1p635nfmiBMmRwyJi2-OiTELmpgdGA@mail.gmail.com
Whole thread Raw
In response to Re: no syntax error on limit1  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: Re: no syntax error on limit1
Next
From: Jov
Date:
Subject: Re: no syntax error on limit1