Request a Demo
Home   >   mailing lists

Re: Query in function not using index... - Mailing list pgsql-general

From Listmail
Subject Re: Query in function not using index...
Date
Msg-id op.trgkiqmuzcizji@apollo13
Whole thread Raw
In response to Query in function not using index...  (John Cole <john.cole@uai.com>)
Responses Re: Query in function not using index...
List pgsql-general
Tree view 

> Any idea why using a variable v_streetName instead of a string 'wynn%'
> behaves differently?

    Yeah.
    'wynn%' doesn't start with % so LIKE uses index.
    But Postgres doesn't know that you know that the contents of this
variable never starts with '%'...


>
> Thanks,
>
> John
>

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Preferred Installation/Data Directories
Next
From: Russ Brown
Date:
Subject: Re: Preferred Installation/Data Directories