Re: [GENERAL] Re: Feature proposal and discussion: full-fledged column/function equivalence

2014-08-07 Thread Tom Lane
David Johnston david.g.johns...@gmail.com writes: On Fri, Aug 1, 2014 at 6:22 PM, Chris Travers chris.trav...@gmail.com wrote: On Fri, Aug 1, 2014 at 12:19 PM, David G Johnston david.g.johns...@gmail.com wrote: More to the point: if you are writing a multiple-relation query and have

[GENERAL] Re: Feature proposal and discussion: full-fledged column/function equivalence

2014-08-01 Thread David G Johnston
Vik Fearing wrote CREATE testfunction(test) returns int language sql as $$ select 1; $$; SELECT testfunction FROM test; That would allow first-class calculated columns. I assume the work is mostly at the parser/grammatical level. Is there any reason why supporting that would be a bad

Re: [GENERAL] Re: Feature proposal and discussion: full-fledged column/function equivalence

2014-08-01 Thread Chris Travers
On Fri, Aug 1, 2014 at 12:19 PM, David G Johnston david.g.johns...@gmail.com wrote: Vik Fearing wrote CREATE testfunction(test) returns int language sql as $$ select 1; $$; SELECT testfunction FROM test; That would allow first-class calculated columns. I assume the work is mostly at

Re: [GENERAL] Re: Feature proposal and discussion: full-fledged column/function equivalence

2014-08-01 Thread David Johnston
On Fri, Aug 1, 2014 at 6:22 PM, Chris Travers chris.trav...@gmail.com wrote: On Fri, Aug 1, 2014 at 12:19 PM, David G Johnston david.g.johns...@gmail.com wrote: Vik Fearing wrote CREATE testfunction(test) returns int language sql as $$ select 1; $$; SELECT testfunction FROM test;