Re: Index not being used ?
От | Ron Johnson |
---|---|
Тема | Re: Index not being used ? |
Дата | |
Msg-id | 1062650626.7342.444.camel@haggis обсуждение исходный текст |
Ответ на | Re: Index not being used ? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: