Multiples concatenation operator (||) - Mailing list pgsql-hackers

From Ricardo J.C.Coelho
Subject Multiples concatenation operator (||)
Date
Msg-id 01BE552E.6C51A860.pulsar@truenet-ce.com.br
Whole thread Raw
Responses Re: [HACKERS] Multiples concatenation operator (||)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: Possible bug on update
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Multiples concatenation operator (||)