Re: temporal period type and select distinct gives equality error

From: Arturo Perez <arturo(at)pleeque(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: temporal period type and select distinct gives equality error
Date: 2011-01-26 14:27:28
Message-ID: arturo-5A98DD.09272826012011@ip72-204-46-200.fv.ks.cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <arturo-26A95E(dot)00305123012011(at)news(dot)gmane(dot)org>,
arturo(at)pleeque(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2011-01-26 15:04:46 Re: Understanding PG9.0 streaming replication feature
Previous Message Bill Moran 2011-01-26 14:09:29 Re: Store base64 in database. Use bytea or text?