On Mon, 14 Feb 2005, Ivan Voras wrote:
> Stephan Szabo wrote:
> > On Mon, 14 Feb 2005, Ivan Voras wrote:
>
> >>Could you give me an example for this, or point me to the relevant
> >>documentation?
>
> >
> > http://www.postgresql.org/docs/8.0/interactive/indexes-opclass.html
>
> Thanks! I didn't kn
Stephan Szabo wrote:
On Mon, 14 Feb 2005, Ivan Voras wrote:
Could you give me an example for this, or point me to the relevant
documentation?
http://www.postgresql.org/docs/8.0/interactive/indexes-opclass.html
Thanks! I didn't know this and I certainly didn't think it would be that
easy :)
-
On Mon, 14 Feb 2005, Ivan Voras wrote:
> Stephan Szabo wrote:
>
> > You can also create an index using a _pattern_ops operator
> > class which should be usable even with other collations.
>
> Could you give me an example for this, or point me to the relevant
> documentation?
Basically, you could
On Mon, 14 Feb 2005, Ivan Voras wrote:
> PFC wrote:
> >
> > normally you shouldn't have to do anything, it should just work :
> >
> >> select field from table where field like 'abc%'
>
> > If it does not use the index, I saw on the mailing list that the
> > locale could be an issue.
>
> O
Stephan Szabo wrote:
You can also create an index using a _pattern_ops operator
class which should be usable even with other collations.
Could you give me an example for this, or point me to the relevant
documentation?
---(end of broadcast)---
TIP 6
PFC wrote:
normally you shouldn't have to do anything, it should just work :
select field from table where field like 'abc%'
If it does not use the index, I saw on the mailing list that the
locale could be an issue.
Oh yes, I forgot about that :( I do have LC_COLLATE (on latin2)...
It's
normally you shouldn't have to do anything, it should just work :
select field from table where field like 'abc%'
CREATE INDEX ... ON table( field );
that's all
If it does not use the index, I saw on the mailing list that the locale
could be an issue.
---(end
