Re: bug with distinct?

Alfonso Peniche <alfonso@iteso.mx> writes:
>      SELECT distinct 'mod_type' ,currval('mytable_idmytable_seq') from
> mytable;
> ERROR:  Unable to identify an ordering operator '<' for type 'unknown'
>  Use an explicit ordering operator or modify the query

You need to give the literal an explicit type, eg,

     SELECT distinct 'mod_type'::text, currval('mytable_idmytable_seq') from
     mytable;

7.1 will default to assuming that you meant 'text' in this scenario,
but older releases are pickier.

            regards, tom lane