On 11/04/2015 10:46 PM, Pavel Stehule wrote: > 2015-11-05 7:39 GMT+01:00 Craig Ringer wrote: > I see constant confusion between \copy and COPY. It's a really good > reason NOT to overload other psql commands IMO. > > but crosstab is one old function from old extension with unfriendly > design.
Hey, I resemble that remark ;-)
I am sorry, Joe - no any personal attack - I'll pay a beer for you if you visit Prague :)
Pavel
> When we support PIVOT/UNPIVOT - the crosstab function will be > obsolete. It is not often used command.
But agreed, once we have proper support for PIVOT built into the grammar, the entire tablefunc extension becomes obsolete, so perhaps overloading \crosstab is not so bad. Joe
-- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development