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

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

Fri, 26 Jun 1998 18:35:44 -0700 (PDT)
Brett McCormick <brett@work.chicken.org>
operator error