Re: disable seqscan - Mailing list pgsql-general

From Alban Hertroys
Subject Re: disable seqscan
Date
Msg-id 9062FD1C-C911-40D3-A1A3-843B5CCA5C9E@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: disable seqscan  (Nick Raj <nickrajjain@gmail.com>)
List pgsql-general
On 24 May 2011, at 8:22, Nick Raj wrote:
> One think i am not able to understand is, if i use ndpoint_overlap method it is going for seq. scan every time but if
iuse && operator it is using index scan. Why it is so? 

> Why these is happening?

Tom already explained that, but in short: Because a function is not an operator.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4ddb741511921606159980!



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: strange behaviour in 9.0.2 / ERROR: 22003: value out of range: overflow
Next
From: Trenta sis
Date:
Subject: Re: Postgres questions