Re: temporal period type and select distinct gives equality error
От | Arturo Perez |
---|---|
Тема | Re: temporal period type and select distinct gives equality error |
Дата | |
Msg-id | arturo-5A98DD.09272826012011@ip72-204-46-200.fv.ks.cox.net обсуждение исходный текст |
Ответ на | temporal period type and select distinct gives equality error (Arturo Perez <arturo@pleeque.com>) |
Ответы |
Re: temporal period type and select distinct gives
equality error
|
Список | pgsql-general |
In article <arturo-26A95E.00305123012011@news.gmane.org>, arturo@pleeque.com (Arturo Perez) wrote: > Hi all, > > I'm using the temporal contrib package that creates the period type and > a bunch of operators in postgresql 8.4.5. I plan to use the same code > against 9.0 so if anything differs between the two regarding this issue > please let me know. > > In psql the \do command shows this > public | = | period | period | boolean | > > and yet when I do a select distinct with a join I get > > QueryLogger - *** error. > org.postgresql.util.PSQLException: ERROR: could not identify an equality > operator for type period > > If I leave the period column out of the select list then it works fine. > > Did I install it wrong? Or is something else going on? > > tia > arturo No suggestions from anyone? Anyone out there? :-) -arturo
В списке pgsql-general по дате отправления: