Re: warning: pg_query(): Query failed - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: warning: pg_query(): Query failed
Date
Msg-id 20050107062515.GA9861@wolff.to
Whole thread Raw
In response to Re: warning: pg_query(): Query failed  (Aaron Steele <asteele@berkeley.edu>)
List 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 by date:

Previous
From: "Murali Mohan Kasetty"
Date:
Subject: unsubscribe
Next
From: Michael Glaesemann
Date:
Subject: Re: Serial Foreign Key