Search Postgresql Archives

Re: Query in function not using index...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "John Cole" <john.cole@xxxxxxx>, "'Tom Lane'" <tgl@xxxxxxxxxxxxx>
Subject: Re: Query in function not using index...
From: Listmail <lists@xxxxxxxxxx>
Date: Sat, 28 Apr 2007 09:13:22 +0200
Cc: "'pgsql-general@xxxxxxxxxxxxxx'" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <76758090F8686C47A44B6FF52514A1D307909C5D@xxxxxxxxxxxxxx>
References: <76758090F8686C47A44B6FF52514A1D307909C5D@xxxxxxxxxxxxxx>
User-agent: Opera Mail/9.10 (Linux)

Tom,
We were looking at the explain results and noticed that it wasconverting
the 'wynn%' into fname >= 'wynn' and fname < 'wyno'


	Does this also work if the last character is a unicode character ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Query in function not using index...
  - From: Tom Lane

References:
- Re: Query in function not using index...
  - From: John Cole

Prev by Date: Re: FIN_WAIT_2
Next by Date: Re: Processing a work queue
Previous by thread: Re: Query in function not using index...
Next by thread: Re: Query in function not using index...
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux