Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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..

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-06-27 02:11:56
Subject: Re: [SQL] isnull function]
Previous:From: Kachun LeeDate: 1998-06-27 00:32:33
Subject: isnull function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group