Re: select distinct null

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: karol(at)gmweltel(dot)com(dot)pl
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: select distinct null
Date: 2001-01-05 16:39:17
Message-ID: 10217.978712757@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<karol(at)gmweltel(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-05 16:43:24 Re: Explain
Previous Message Richard Poole 2001-01-05 16:34:09 PL/pgSQL NOT NULL variables