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
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? |