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.
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 |