pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kris Kiger <kris@musicrebellion.com>
To: pgsql-admin@postgresql.org
Subject: Bug?
Date: Thu, 01 Jul 2004 11:08:55 -0500
Message-ID: <40E43717.2070304@musicrebellion.com> (raw)
References: <671060015.20031010095617@roaddep.ru>

    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.







Message-ID: <40E43717.2070304@musicrebellion.com>
Permalink:  ../40E43717.2070304@musicrebellion.com/
Also on:    postgresql.org/message-id/40E43717.2070304@musicrebellion.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kris@musicrebellion.com
  Subject: Re: Bug?
  In-Reply-To: <40E43717.2070304@musicrebellion.com>
  References: <671060015.20031010095617@roaddep.ru> <40E43717.2070304@musicrebellion.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox