Re: bug with distinct?

Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> 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
> 
Thanx, it woeks great now.

Cheers

---