Multiples concatenation operator (||)

Started by Ricardo J.C.Coelhoalmost 27 years ago2 messages
#1Ricardo J.C.Coelho
pulsar@truenet-ce.com.br

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.

#2Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Ricardo J.C.Coelho (#1)
Re: [HACKERS] 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