BUG #5193: should "select * from ab limitkkk" cause a syntax error? - Mailing list pgsql-bugs

From
Subject BUG #5193: should "select * from ab limitkkk" cause a syntax error?
Date
Msg-id 200911170130.nAH1UEjZ081049@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5193: should "select * from ab limitkkk" cause a syntax error?
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5193
Logged by:
Email address:      donniehan@126.com
PostgreSQL version: 8.4.1
Operating system:   Windows XP
Description:        should "select * from ab limitkkk" cause a syntax error?
Details:

Hi guys,

The following sql statement is not illegal

But pg can run it.

postgres=# select * from a limitkkk;  ---->(seems equal "limit null")
 a
---
 1
 1
 1
 1
 1
(5 rows)

Should pg throws a syntax error?

Regards
-Dongni

pgsql-bugs by date:

Previous
From: "Thomas S. Chin"
Date:
Subject: Re: BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior
Next
From: Tom Lane
Date:
Subject: Re: BUG #5193: should "select * from ab limitkkk" cause a syntax error?