here the limit1 is a table alias， = as limit1 jov 在 2013-10-9 下午8:27，"Willy-Bas Loos" <willy...@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 >
