Re: no syntax error on limit1

From: Jov <zhao6014(at)gmail(dot)com>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: no syntax error on limit1
Date: 2013-10-09 12:42:11
Message-ID: CADyrUxOoHNNZswEukL7AEReHjKVuo=LNDVBAbMKtmyuW1d_FmA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

here the limit1 is a table alias， = as limit1

jov
在 2013-10-9 下午8:27，"Willy-Bas Loos" <willybas(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-10-09 13:20:44 Re: Incorrect index being used
Previous Message Willy-Bas Loos 2013-10-09 12:33:15 Re: no syntax error on limit1