Обсуждение: 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 "%".

Ricardo Coelho.

> 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,
Pennsylvania19026