Thread

operator error

Brett McCormick <brett@work.chicken.org> — 1998-06-27T01:35:44Z

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