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

Mark Cave-Ayland m.cave-ayland at webbased.co.uk
Fri Nov 4 08:52:07 PST 2005


> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Markus Schaber
> Sent: 04 November 2005 16:24
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] how to define an alias for && operator?
> 
> 
> Hi, Strk,
> 
> strk at refractions.net wrote:
> > I would be surprised if you get that function to use an 
> index. Did you 
> > verify it ?
> 
> I would not be so surprised, as it is in defined in the 'sql' 
> language as opposed to 'plpgsql'. I remember having read that 
> the query planner is able to inline 'sql' language functions 
> before optimizing the query plan.
> 
> Markus


More PostgreSQL voodoo. Impressive :)


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.





More information about the postgis-users mailing list