On Thu, 18 Nov 2004, PostgreSQL Bugs List wrote:
> select * from tbinvoicerows
> where invoicecd = 'FLOCAA0025'
>
> result in 0 seconde with 2 records NO BUG
>
> select * from tbinvoicerows
> where invoicecd like '%FLOCAA0025%'
>
> result in 40 secondes with 2 records NO BUG
>
> selec
PostgreSQL Bugs List wrote:
The following bug has been logged online:
Bug reference: 1325
Logged by: gregory
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0 Beta
Operating system: win2000
Description:like error
after
I copy 5 millions lignes on the table
sele
The following bug has been logged online:
Bug reference: 1325
Logged by: gregory
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0 Beta
Operating system: win2000
Description:like error
Details:
I create a table
CREATE TABLE tbinvoicerows
(
invoicecd