| 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: | Whole Thread | Raw Message | 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 |