Re: String concatenation operator which keeps trailing spaces in CHAR(n) columns - Mailing list pgsql-general

On Wed, Jul 30, 2014 at 5:43 AM, Andrus <kobruleht2@hot.ee> wrote:
> How to create string concatenation operator which preserves trailing spaces
> on CHAR(n) type columns ?

hm, why do that at all?   how about avoid the char() type and create
views over tables using rpad when you want space padding:

create view v_foo as
  select *, rpad(f, 50, ' ') as f_padded;

merlinm