|| versus concat( ), diff behavior

From: <david(dot)sahagian(at)emc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: || versus concat( ), diff behavior
Date: 2012-03-02 20:58:22
Message-ID: F3CBFBA88397EA498B22A05FFA9EC49D66023883@MX22A.corp.emc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2012-03-02 21:14:50 Re: || versus concat( ), diff behavior
Previous Message Tom Lane 2012-03-02 18:58:50 Re: concatenating text and bytea