Re: bug with distinct? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: bug with distinct?
Date
Msg-id Pine.LNX.4.30.0102100216530.1286-100000@peter.localdomain
Whole thread Raw
In response to bug with distinct?  (Alfonso Peniche <alfonso@iteso.mx>)
List pgsql-general
Alfonso Peniche writes:

>      SELECT distinct 'mod_type' ,currval('mytable_idmytable_seq') from
> mytable;
>
> and I get the message:
>
> ERROR:  Unable to identify an ordering operator '<' for type 'unknown'
>  Use an explicit ordering operator or modify the query

Use 'mod_type'::text.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Re: Re: PostgreSQL over NFS?
Next
From: "George Johnson"
Date:
Subject: two cents