operator error

From: Brett McCormick <brett(at)work(dot)chicken(dot)org>
To: pgsql-hackers(at)hub(dot)org
Subject: operator error
Date: 1998-06-27 01:35:44
Message-ID: 13716.19568.251936.318748@web0.speakeasy.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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..

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-06-27 02:11:56 Re: [SQL] isnull function]
Previous Message Kachun Lee 1998-06-27 00:32:33 isnull function