Can anyone explain the following:

hannu=> select 1 + 2 + 3 + 4;
?column?
--------
      10
(1 row)

works fine, but:

hannu=> select '1' || '2' || '3';
ERROR:  parser: parse error at or near "||"
hannu=> select ('1' || '2') || '3';
NOTICE:  there is more than one operator || for types
NOTICE:  unknown and unknown. You will have to retype this query
ERROR:  using an explicit cast
hannu=> select ('1'::text || '2') || '3';
?column?
--------
     123
(1 row)

I understand the 'there is more than one operator' errors, but
what is so different between operators + and || ?

Hannu

Responses

• Re: [HACKERS] Possible bug in parsing at 1998-03-18 06:54:31 from Thomas G. Lockhart

pgsql-hackers by date

Next:	From: Pedro J. Lobo	Date: 1998-03-17 12:06:59
	Subject: Unix Domain Sockets error (was Re: [HACKERS] Alpha initdb fixed!)
Previous:	From: Andrew Martin	Date: 1998-03-17 10:50:32
	Subject: Re: [HACKERS] First mega-patch...