Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1171: select distinct 'value',... fails. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1171: select distinct 'value',... fails.
Date
Msg-id 21282.1087575206@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1171: select distinct 'value',... fails.  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
>     select distinct 'value';
> ERROR:  Unable to identify an ordering operator '<' for type '"unknown"'
>         Use an explicit ordering operator or modify the query

This is accepted in 7.4 and later.  You are evidently using something
older.

            regards, tom lane

pgsql-bugs by date:

Previous
From: zakkr@zf.jcu.cz
Date:
Subject: question
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1173: Sig 11 in insert