Search Postgresql Archives

Re: temporal period type and select distinct gives equality error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In article <arturo-26A95E.00305123012011@xxxxxxxxxxxxxx>,
 arturo@xxxxxxxxxxx (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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux