|| versus concat( ), diff behavior - Mailing list pgsql-general

From
Subject || versus concat( ), diff behavior
Date
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D66023883@MX22A.corp.emc.com
Whole thread Raw
Responses Re: || versus concat( ), diff behavior
Re: || versus concat( ), diff behavior
List pgsql-general
Can anybody please point me to where this "difference of behavior" is explained/documented ?
Thanks,
-dvs-

-- version = 9.1.3
do $$
declare
  v_str  char(10);
begin
  v_str := 'abc' ;
  raise info '%', concat(v_str, v_str) ;
  raise info '%', v_str||v_str ;
end
$$;

INFO:  abc       abc
INFO:  abcabc



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: concatenating text and bytea
Next
From: Ben Chobot
Date:
Subject: Re: || versus concat( ), diff behavior