Re: [BUGS] BUG #1325: like error

2004-11-18 Thread Stephan Szabo
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

Re: [BUGS] BUG #1325: like error

2004-11-18 Thread Richard Huxton
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

[BUGS] BUG #1325: like error

2004-11-18 Thread PostgreSQL Bugs List
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