Re: Query planner isn't using my indices

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Query planner isn't using my indices
Дата
Msg-id 20020111000544.A32620@svana.org
обсуждение исходный текст
Ответ на Re: Query planner isn't using my indices  ("Alaric B. Snell" <abs@frontwire.com>)
Ответы Re: Query planner isn't using my indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, Jan 10, 2002 at 12:18:33PM +0000, Alaric B. Snell wrote:
> On 9 Jan 2002, Doug McNaught wrote:
>
> > Finite developer resources?  Feel free to pitch in once the 7.3 cycle
> > starts.
>
> Smile, everyone!
>
> I'm going to pitch to my employer to let me fix it on company time, since
> it's causing problems for us with JBoss (which generates most of the
> queries for us, out of our control).

Interestingly, I find the easiest fix is: never use unquoted constants.

If it didn't break other peoples queries I'd suggest modifying the parser so
that numbers are parsed as strings of type unknown instead of numbers. Then
let the normal type matching system go to work on it.

That said, a good system for type promotion would be cool.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jochem van Dieten
Дата:
Сообщение: Re: select few fields as a single field
Следующее
От: "Ben-Nes Michael"
Дата:
Сообщение: Q about function