Re: [GENERAL] temporal period type and select distinct gives equality error

2011-01-28 Thread Jeff Davis
On Thu, 2011-01-27 at 07:32 -0500, Arturo Perez wrote: > I thought I saw that in CVS but when I checked it out and installed it > the error did not go away. > > Let me try that again. Do you think I'd need to reinstall the server > itself to insure the proper behavior? No, reinstalling the ext

Re: [GENERAL] temporal period type and select distinct gives equality error

2011-01-27 Thread Arturo Perez
In article <1296066333.11513.364.camel@jdavis>, Jeff Davis wrote: > On Wed, 2011-01-26 at 09:27 -0500, Arturo Perez wrote: > > > and yet when I do a select distinct with a join I get > > > > > > QueryLogger - *** error. > > > org.postgresql.util.PSQLException: ERROR: could not identify an equal

Re: [GENERAL] temporal period type and select distinct gives equality error

2011-01-26 Thread Jeff Davis
On Wed, 2011-01-26 at 09:27 -0500, Arturo Perez wrote: > > 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

Re: [GENERAL] temporal period type and select distinct gives equality error

2011-01-26 Thread Arturo Perez
In article , art...@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 > plea

[GENERAL] temporal period type and select distinct gives equality error

2011-01-23 Thread Arturo Perez
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 | =|