| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | Jorge Godoy <jgodoy(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
| Subject: | Re: Crosstab Problems |
| Date: | 2007-10-25 04:37:26 |
| Message-ID: | 6329.1193287046@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
Joe Conway <mail(at)joeconway(dot)com> writes:
> Tom Lane wrote:
>> 1. Treat NULL rowid as a category in its own right. This would conform
>> with the behavior of GROUP BY and DISTINCT, for instance.
> In any case, the attached changes the behavior to #1 for both flavors of
> crosstab (the original crosstab(text, int) and the usually more useful
> crosstab(text, text)).
> It is appropriate for 8.3 but not back-patching as it changes behavior
> in a non-backward compatible way and is probably too invasive anyway.
Um, if the previous code crashed in this case, why would you worry about
being backward-compatible with it? You're effectively changing the
behavior anyway, so you might as well make it do what you've decided is
the right thing.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2007-10-25 06:05:32 | Re: Using Postgres as a "embedded" / SQL Lite database on Windows |
| Previous Message | Robert Treat | 2007-10-25 03:23:39 | Re: subversion support? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdenek Kotala | 2007-10-25 08:24:40 | two new chklocale aliases |
| Previous Message | Joe Conway | 2007-10-25 03:59:52 | [Fwd: Re: [GENERAL] Crosstab Problems] |