Sorry, I'm sleeping.
Thanks Gregory-san. and, Tom-san.
Gregory Stark <[EMAIL PROTECTED]> writes:
But yeah, c_expr isn't enough. We really need {a,b}_expr sans postfix
expressions.
How's that going to help? As long as postfix operators exist at all,
SELECT a + b, ...
is going to be ambiguous, and no amount of grammar magic changes that.
We could force the parser into using one interpretation or the other,
but it would still be wrong for some folks.
Ah yes, {a,b}_expr is very difficult.....Then, I am asking for compromise.
at the "c_expr", case after the patch..
postgres=# select a+b from n;
?column?
----------
5
(1 row)
postgres=# select a+b AS "FIELD" from n;
FIELD
-------
5
(1 row)
postgres=# select a+b "FIELD" from n;
ERROR: syntax error at or near ""FIELD""
LINE 1: select a+b "FIELD" from n;
^
postgres=# select (a+b) "FIELD" from n;
FIELD
-------
5
(1 row)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
