Hi,

Why "||" operator is not associative ?

select 'A' || 'B' || 'C';       results in a parse error at second "||".

If you force the association, it works: select ('A' || 'B') || 'C';

The same thing happen with mod "%".

Ricardo Coelho.


Wed, 10 Feb 1999 19:47:29 -0200
"Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br>
Multiples concatenation operator (||)
> Hi,
> 
> Why "||" operator is not associative ?
> 
> select 'A' || 'B' || 'C';       results in a parse error at second "||".
> 
> If you force the association, it works: select ('A' || 'B') || 'C';
> 
> The same thing happen with mod "%".

It is a problem with the grammer not understanding associativity with
non-standard operators like ||.  No good solution for it.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 10 Feb 1999 18:29:33 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Multiples concatenation operator (||)