merge pg_proc and pg_operator?
От | Peter Eisentraut |
---|---|
Тема | merge pg_proc and pg_operator? |
Дата | |
Msg-id | 1309640525.26660.22.camel@vanquo.pezone.net обсуждение исходный текст |
Ответы |
Re: merge pg_proc and pg_operator?
|
Список | pgsql-hackers |
This thought reemerged in me during the recent discussion of the regular expression matching operators: A lot of things could be better if pg_proc and pg_operator were merged together. Most importantly, operator optimization information could be attached to procedures, so developers and users wouldn't have to make up ever more confusing operator names, and application code would be cleaner, e.g., SELECT * FROM sometable WHERE somehow_intersects(a, b) vs. SELECT * FROM sometable WHERE a ~~@<>@~~ b; Internally, you could delete a lot of duplicate code. In the abstract, an operator is after all just a function call with a different syntax. But you could just as well call "+"(a, b) or a OPERATOR("add") b Once things are out of the parser, it's all the same. What do you think?
В списке pgsql-hackers по дате отправления: