Re: Cast for text->Integer missing in 8.3.5

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cast for text->Integer missing in 8.3.5
Дата
Msg-id 1465.1231881445@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Cast for text->Integer missing in 8.3.5  ("Nykolyn, Andrew" <andrew.nykolyn@ngc.com>)
Список pgsql-general
"Nykolyn, Andrew" <andrew.nykolyn@ngc.com> writes:
> The above has all worked great to get me past the two issues described
> so far.  Now I am having a problem with: function quote_literal is not
> unique.

And you're going to have a few other problems after you get past that.
You can't just insert implicit casts and expect that it will affect only
the situations you want it to affect.  The reason we downgraded the
implicit casts to begin with was exactly that they kicked in too often.

You might try backing off to just having the special || operators
and not the implicit casts, and see if that gets you to where you want,
or at least close enough that fixing your remaining code properly is not
too big a task.  Extra operators are not nearly as dangerous as implicit
casts.

            regards, tom lane

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

Предыдущее
От: Reg Me Please
Дата:
Сообщение: Re: Returning number of matches on a query when using limit
Следующее
От: Jason Long
Дата:
Сообщение: Re: Use PSQLFS for photo storage