Re: select distinct null - Mailing list pgsql-general

From Tom Lane
Subject Re: select distinct null
Date
Msg-id 10217.978712757@sss.pgh.pa.us
Whole thread Raw
In response to Re: select distinct null  (<karol@gmweltel.com.pl>)
List pgsql-general
<karol@gmweltel.com.pl> writes:
> On Thu, 4 Jan 2001, Richard Huxton wrote:
>> Casting the null seems to do it.
>> select distinct null::text,a from foo;
>> works OK on my 7.0 here

> Thanks! It works on my too so I will have hardly any trouble to fix the
> queries.
> But I'm just wondering if there is some solution not involving
> any modification of the query code.

Update to 7.1 ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Explain
Next
From: martin.chantler@convergys.com
Date:
Subject: Re: ODBC failure