Re: select distinct null

From: <karol(at)gmweltel(dot)com(dot)pl>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select distinct null
Date: 2001-01-05 09:27:56
Message-ID: Pine.LNX.4.10.10101051010400.4904-100000@ns.gmweltel.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Karol Wieloch

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message François LODIER 2001-01-05 09:31:17 Disapointed !!
Previous Message Heiko Irrgang 2001-01-05 09:25:12 Re: Explain