operator error - Mailing list pgsql-hackers

From Brett McCormick
Subject operator error
Date
Msg-id 13716.19568.251936.318748@web0.speakeasy.org
Whole thread Raw
List pgsql-hackers
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..

pgsql-hackers by date:

Previous
From: Kachun Lee
Date:
Subject: isnull function
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] isnull function]