| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg ANY/SOME ambiguity wrt sql standard? |
| Date: | 2004-04-28 13:21:00 |
| Message-ID: | Pine.LNX.4.58.0404281456470.28436@sablons.cri.ensmp.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I'm looking into adding sql standard aggregates EVERY/ANY/SOME.
It seems to me that there is a syntax ambiguity with ANY and SOME:
CREATE TABLE bla(b BOOL);
SELECT TRUE = ANY(b) FROM bla;
Is parsed as an array-operator and there is a semantical error because no
array is provided. Now ANY could be an aggregate function call, and it
should be fine.
However I really cannot see (my usual lack of imagination) how to handle
this from the parser.
Thus I'm afraid that I'll have to rewrite the A_Expr structure into a
FuncCall to 'any' or 'some' somewhere.
Comments? Any better idea?
--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Hammond | 2004-04-28 13:28:08 | Re: Is there any method to keep table in memory at startup |
| Previous Message | Tom Lane | 2004-04-28 13:09:01 | Re: Nasty security bug with clustering |