Re: [SQL] String concat operator???

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: webmaster(at)tony(dot)cz, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] String concat operator???
Date: 1999-06-30 13:35:28
Message-ID: l03130304b39fcd381882@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

At 16:16 +0300 on 30/06/1999, webmaster wrote:

> Both id_look and ident are varchars.. So what's wrong with || operator? There
> is an error parsing the querry near || ...
>
> Who is stupid? Me, or postgresql 6.4.2 :) ? It look like legal expression for
> me...

Old problem... "||" doesn't have associativity, so when you use a||b||c, it
gets mixed up. Solution - use (a||b) || c. Preferably ((a||b)||c).

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff MacDonald 1999-06-30 13:56:26 Re: [SQL] Port?
Previous Message Thomas Lockhart 1999-06-30 13:31:51 Re: [PORTS] Port Bug Report: parse error not detected on unterminated quote