[postgis-users] how to define an alias for && operator?

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Jean-Pierre Quirion
> Sent: 04 November 2005 13:26
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] how to define an alias for && operator?
> 
> 
> Hi, 
> 
> Postgis 1.0 
> Postgres 8.0
> 
> We are desperately trying to define an alias for the && 
> operator (that use the same indexes!). We copied the 
> definition of the && operator ("CREATE OPERATOR &&...") that 
> works fine. For index usage we need to add a new operator to 
> the operator class "gist_geometry_ops" but that seems 
> impossible without deleting the && operator, "operator number 
> 3 appears more than once", because && and our new operator 
> should use the same strategy.
> 
> How would you define an alias? We need the alias in order to 
> circumvent Hibernate. Any ideas?
> 
> Jean-Pierre


Hi Jean-Pierre,

Can you show us the exact text you are trying to use in your CREATE OPERATOR
statement?


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com 
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.