bug with distinct?
| От | Alfonso Peniche |
|---|---|
| Тема | bug with distinct? |
| Дата | |
| Msg-id | 3A848A1F.D6E6F3F3@iteso.mx обсуждение |
| Ответы |
Re: bug with distinct?
Re: bug with distinct? |
| Список | pgsql-general |
I dont' know if this a bug or I am just out of my mind, but since it
works with other RDBMS's I decided to ask, so here it goes:
I am trying to do the following:
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
Thinking it could be because of the currval I tried the following:
SELECT distinct 'mod_type', idmytable from mytable
getting the same result.
Am I doing something wrong? Is there a way to do this? Is this a bug?
Thanx
P.S. If someone is wondering what the heck I am trying to do.... I
pretend to insert into a log table, the mod_type for 'mytable' (in this
case insert) and the new inserted row for 'mytable'.
Cheers
В списке pgsql-general по дате отправления: