Bug?

From: Kris Kiger <kris(at)musicrebellion(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Bug?
Date: 2004-07-01 16:08:55
Message-ID: 40E43717.2070304@musicrebellion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

  • at 2003-10-10 03:56:17 from Alexey A. Britchko

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Christophe Weis 2004-07-01 16:23:49 unable to pass variable PGDATA2 into server environment
Previous Message Scott Marlowe 2004-07-01 15:25:29 Re: Postgres IDENT auth problems...