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

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 pg...@j-davis.com 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

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

2011-01-26 Thread Arturo Perez
In article arturo-26a95e.00305123012...@news.gmane.org, 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

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 the select

[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 | =