the query is: update process_order set processresult = 't'::bool and processmsg = '328024' where oid = 25647;
it causes the backend to core dump.
when I don't cast it to 't'::bool, I get this:
ERROR: left-hand side of AND is type 'unknown', not bool
very weird. I wouldn't expect that error when doing an update like
okay, I just realized that i'm using "and" instead of a comma to join
the list of updated value pairs, doh!
after banging by head on a few random objects..
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 1998-06-27 02:11:56|
|Subject: Re: [SQL] isnull function]|
|Previous:||From: Kachun Lee||Date: 1998-06-27 00:32:33|
|Subject: isnull function|