Re: warning: pg_query(): Query failed

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: warning: pg_query(): Query failed
Дата
Msg-id 20050107062515.GA9861@wolff.to
обсуждение исходный текст
Ответ на Re: warning: pg_query(): Query failed  (Aaron Steele <asteele@berkeley.edu>)
Список pgsql-general
On Thu, Jan 06, 2005 at 17:32:30 -0800,
  Aaron Steele <asteele@berkeley.edu> wrote:
> hi bruno,
>
> turns out that l.last_comment_uid and l.last_comment_name are integer
> and char var respectively. since i'm using 7.4.1 with strict boolean
> casting, is there a better alternative to instantiating a different
> version of pgsql on my server?

A better solution is fixing your code. What do you expect it to do
anyhow? Once you figure out what you want it to do, you should be able
to write a boolean expression that is true, false or null when you
want it to be. If fact from what I saw it seems that you could just use
a CASE expression and skip the function call altogether.

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

Предыдущее
От: "Murali Mohan Kasetty"
Дата:
Сообщение: unsubscribe
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Serial Foreign Key