Postgres Pro
Downloads
Home   >   mailing lists

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

From Jov
Subject Re: no syntax error on limit1
Date
Msg-id CADyrUxOoHNNZswEukL7AEReHjKVuo=LNDVBAbMKtmyuW1d_FmA@mail.gmail.com
Whole thread Raw
In response to no syntax error on limit1  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
Tree view

here the limit1 is a table alias， = as limit1

jov

在 2013-10-9 下午8:27，"Willy-Bas Loos" <willybas@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 clarity of purpose" -- Mark Shuttleworth

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: no syntax error on limit1
Next
From: Albe Laurenz
Date:
Subject: Re: Incorrect index being used