Re: bug with distinct?

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/