here the limit1 is a table alias, = as limit1
jov
在 2013-10-9 下午8:27,"Willy-Bas Loos" <willybas@xxxxxxxxx>写道:
WBLCheers,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
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth