Re: \crosstabview fixes - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: \crosstabview fixes
Date
Msg-id 20160414094710.GD11804@msg.df7cb.de
Whole thread Raw
In response to Re: \crosstabview fixes  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: \crosstabview fixes  ("Daniel Verite" <daniel@manitou-mail.org>)
Re: \crosstabview fixes  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-hackers
Re: Daniel Verite 2016-04-14 <bc3a2e99-5030-4466-a248-98c5e9841205@mm>
> I don't quite see how to work around that, short of simply
> removing the possibility of addressing columns by their
> numbers. Which maybe is a bit sad for the end user, I'm not
> sure, but ISTM that's a logical consequence of abandoning
> the dedicated parser for columns.

That would be bad news, given that \crosstabview is meant for
interactive use where these number shortcuts are much more likely to
be used than in proper production SQL code. Be it only for ease of
typing, or for the case where the columns are just called ?column?.

If there's no way out, what about changing it the other way, i.e.
breaking the case where the column is named by a number? That seems
much less of a problem in practice.

Christoph



pgsql-hackers by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: \crosstabview fixes
Next
From: Bernd Helmle
Date:
Subject: Re: Problems with huge_pages and IBM Power8