pg ANY/SOME ambiguity wrt sql standard?
| От | Fabien COELHO | 
|---|---|
| Тема | pg ANY/SOME ambiguity wrt sql standard? | 
| Дата | |
| Msg-id | Pine.LNX.4.58.0404281456470.28436@sablons.cri.ensmp.fr обсуждение исходный текст | 
| Ответы | Re: pg ANY/SOME ambiguity wrt sql standard? Re: pg ANY/SOME ambiguity wrt sql standard? | 
| Список | 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@cri.ensmp.fr
В списке pgsql-hackers по дате отправления: