temporal period type and select distinct gives equality error - Mailing list pgsql-general

From Arturo Perez
Subject temporal period type and select distinct gives equality error
Date
Msg-id arturo-26A95E.00305123012011@news.gmane.org
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Server stops responding in every week
Next
From: Ben Chobot
Date:
Subject: Re: Postgresql as a dictionary coder backend?