select distinct null

Поиск
Список
Период
Сортировка
От
Тема select distinct null
Дата
Msg-id Pine.LNX.4.10.10101041400140.3279-100000@ns.gmweltel.com.pl
обсуждение исходный текст
Список pgsql-general
Hello!

I've got problem with such a query:

INSERT INTO table1 VALUES SELECT DISTINCT null,table2.atr1 FROM table2
WHERE table2.atr1 > 0;

It works in PostgreSQL 6.4.2 but in 7.0.3 it returns:

ERROR:  Unable to identify an ordering operator '<' for type 'unknown'
        Use an explicit ordering operator or modify the query

I discovered that PostgreSQL 7.0.3 doesn't accept the querry:

select distinct null;

and reurns the same error.

I use such queries in some client applications and it would be hard
to rewrite them. Could anyone explain to me what has been changed in 7.0.3
and how can I solve the problem on the server side.

Thanks in advance.

Karol Wieloch


В списке pgsql-general по дате отправления:

Предыдущее
От: Jose Soares
Дата:
Сообщение: Re: Table msysconf
Следующее
От: Marc SCHAEFER
Дата:
Сообщение: libpq-fe: how to determine unique collision ?