Re: [HACKERS] Group By, NULL values and inconsistent behaviour.

From: darrenk(at)insightdist(dot)com (Darren King)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Group By, NULL values and inconsistent behaviour.
Date: 1998-01-26 21:43:38
Message-ID: 9801262143.AA69550@ceodev
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > >For now, ignore the patch I sent. Appears from Andreas demo that the
> > >current postgres code will follow the Informix style with regard to
> > >grouping columns with NULL values. Now that I really think about it,
> > >it does make more sense.
> >
> > I think I saw the patch committed this morning...?
>
> Yesterday evening, actually...should we back it out, or leave it
> as is? Is the old way more corrrect the the new?

Marc,

>From the two responses demonstrating Informix and Sybase, I think the patch
I sent should be backed out. I can live with NULL equaling NULL in the
GROUP BY and ORDER BY clauses, but not in the WHERE clause, if everyone else
is doing it that way.

darrenk

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-01-26 22:31:15 Re: [HACKERS] postmaster crash and .s.pgsql file
Previous Message Bruce Momjian 1998-01-26 21:28:21 postmaster crash and .s.pgsql file