Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA81772 for ; Wed, 28 Jul 1999 20:15:52 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id UAA25843; Wed, 28 Jul 1999 20:13:24 -0400 (EDT) To: jens@jens.de cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] COALESCE() bug? In-reply-to: Your message of Thu, 29 Jul 1999 01:29:57 +0000 (CEST) Date: Wed, 28 Jul 1999 20:13:24 -0400 Message-ID: <25841.933207204@sss.pgh.pa.us> From: Tom Lane Jens Glaser writes: > the following SQL statement gives an error: > ERROR: fix_indxqual_references: Cannot handle node type 723 Interesting. I wouldn't have thought 6.5 would try to use an index with an expression involving COALESCE(). Evidently it does. I'll take a look, but I can't guarantee that the fix is simple enough to back-patch into 6.5 ... you might have to drop the index on pt.objectid to get this to work :-( regards, tom lane