Re: bug with distinct?

Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Alfonso Peniche <alfonso(at)iteso(dot)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
>
Thanx, it woeks great now.

Cheers

---