X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 29405D1B18C for ; Thu, 1 Jul 2004 13:09:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18108-06 for ; Thu, 1 Jul 2004 16:09:28 +0000 (GMT) Received: from stamp.musicrebellion.com (unknown [209.120.177.10]) by svr1.postgresql.org (Postfix) with ESMTP id DA270D1B172 for ; Thu, 1 Jul 2004 13:09:26 -0300 (ADT) Received: from dsl093-203-229.ind1.dsl.speakeasy.net ([66.93.203.229] helo=musicrebellion.com) by stamp.musicrebellion.com with asmtp (Exim 4.30 #2 (Debian)) id 1Bg47n-0004F2-BQ for ; Thu, 01 Jul 2004 11:09:23 -0500 Message-ID: <40E43717.2070304@musicrebellion.com> Date: Thu, 01 Jul 2004 11:08:55 -0500 From: Kris Kiger User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020623 Debian/1.0.0-0.woody.1 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Bug? References: <671060015.20031010095617@roaddep.ru> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/10 X-Sequence-Number: 14078 select * from temptable where tempcolumn != 'blah'||'blah'; or select * from temptable where tempcolumn <> 'blah'||'blah'; I could be wrong, but there may be an bug in the order of precedence. If you try the above query, postgres will return: ERROR: array value must start with "{" or dimension information If you group the expressions as; select * from temptable where tempcolumn != ('blah'||'blah'); or select * from temptable where tempcolumn <> ('blah'||'blah'); it works like a charm. Just curious if there is a reason for this order of operation. Thanks Kris ______________________________ Kris Kiger Software Developer Digonex Technologies, Inc. 317.638.4174 Fax CONFIDENTIALITY NOTICE: The information in this transmission is private, confidential, may be legally privileged, is property of the sender and is intended solely for the use of the addressee. If you are not the addressee, you should not read, disclose, distribute, copy, use or rely upon the information contained in this transmission. If you have received this transmission in error please delete or destroy it and notify DIGONEX TECHNOLOGIES, INC. immediately at (317) 638-4154.