[GENERAL] User defined operator fails to work in EXCLUDE constraint

2014-04-13 Thread Paul Jones
I tried to define my own circle operator to use in an EXCLUDE constraint but it fails to detect insertion of rows that should not be simultaneously be allowed in the table.  The operator compares two circles' radii and works for a simple SELECT.  What am I doing wrong? Here is the code to

Re: [GENERAL] User defined operator fails to work in EXCLUDE constraint

2014-04-13 Thread Tom Lane
Paul Jones p...@cmicdo.com writes: I tried to define my own circle operator to use in an EXCLUDE constraint but it fails to detect insertion of rows that should not be simultaneously be allowed in the table.  The operator compares two circles' radii and works for a simple SELECT.  What am I

Re: [GENERAL] User defined operator fails to work in EXCLUDE constraint

2014-04-13 Thread Paul Jones
- Original Message - From: Tom Lane t...@sss.pgh.pa.us To: Paul Jones p...@cmicdo.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Sunday, April 13, 2014 4:25 PM Subject: Re: [GENERAL] User defined operator fails to work in EXCLUDE constraint Paul Jones