String concatenation operator which keeps trailing spaces in CHAR(n) columns

Поиск
Список
Период
Сортировка
От Andrus
Тема String concatenation operator which keeps trailing spaces in CHAR(n) columns
Дата
Msg-id 85033C87F2984B1B878D9718B790702D@dell2
обсуждение исходный текст
Ответы Re: String concatenation operator which keeps trailing spaces in CHAR(n) columns  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: String concatenation operator which keeps trailing spaces in CHAR(n) columns  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
How to create string concatenation operator which preserves trailing spaces
on CHAR(n) type columns ?

I tried code below, but it returns AB (without spaces).
How to force it to return A B (keep space after A) ?

Andrus.

CREATE OR REPLACE FUNCTION public.stringconcat(left text, right text)
RETURNS text
LANGUAGE sql IMMUTABLE
AS $BODY$
SELECT concat($1, $2) ;
$BODY$;

CREATE OPERATOR public.+ (
    leftarg = text,
    rightarg = text,
    procedure = public.stringconcat
);

create temp table test (col1  char(2)) on commit drop;
insert into test values ('A');
select col1 +  'B'
   from test;


I posted similar question also in


http://stackoverflow.com/questions/24975118/how-to-create-string-concatenation-operator-which-preserves-trailing-spaces-in-c




В списке pgsql-general по дате отправления:

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: statement_timeout doesn't work
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: String concatenation operator which keeps trailing spaces in CHAR(n) columns