Re: warning: pg_query(): Query failed

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Aaron Steele <asteele(at)berkeley(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: warning: pg_query(): Query failed
Date: 2005-01-07 06:25:15
Message-ID: 20050107062515.GA9861@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 06, 2005 at 17:32:30 -0800,
Aaron Steele <asteele(at)berkeley(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2005-01-07 06:37:48 Re: Serial Foreign Key
Previous Message Jonathan Stafford 2005-01-07 05:45:38 Serial Foreign Key