Re: Index not being used ?

On Wed, 2003-09-03 at 22:27, Tom Lane wrote:
> 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 ...

Well, yes, that's what I was thinking: minimize the code path that
the parser must take.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Basically, I got on the plane with a bomb. Basically, I tried
to ignite it. Basically, yeah, I intended to damage the plane."
RICHARD REID, tried to blow up American Airlines Flight 63