Re: Index not being used ?

Ron Johnson <ron.l.johnson@cox.net> writes:
> Quotes and casting together are not necessary.

Check.

> I'd choose "lid = 457::int2" since it's telling PG what the datatype
> is, whereas with lid = '457', PG must figure it out.

I'd lean to the quotes, actually, since that way your application's
code isn't so dependent on the particular datatypes in the table.
I doubt there's any performance advantage to writing the cast, if
that's what you were thinking ...

            regards, tom lane