Re: BUG #5193: should "select * from ab limitkkk" cause a syntax error?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "" <donniehan(at)126(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5193: should "select * from ab limitkkk" cause a syntax error?
Date: 2009-11-17 01:34:40
Message-ID: 17180.1258421680@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"" <donniehan(at)126(dot)com> writes:
> postgres=# select * from a limitkkk; ---->(seems equal "limit null")

> Should pg throws a syntax error?

If we did, we'd be violating the SQL standard. The "limitkkk"
is a perfectly valid table alias. There's no AS in front of it,
but unfortunately the spec allows and even encourages people to
omit AS.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message goldenhawking 2009-11-17 05:26:30 BUG #5194: fire IDispatch Error #3015 when run PutCollect() in ADO
Previous Message donniehan 2009-11-17 01:30:14 BUG #5193: should "select * from ab limitkkk" cause a syntax error?