Re: select distinct null - Mailing list 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