Search Postgresql Archives

Re: no syntax error on limit1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



duh!
thx.


On Wed, Oct 9, 2013 at 2:30 PM, Szymon Guz <mabewlun@xxxxxxxxx> wrote:

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux