[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] String concatenation operator which keeps trailing spaces in CHAR(n) columns
From:       "Andrus" <kobruleht2 () hot ! ee>
Date:       2014-07-31 13:24:04
Message-ID: EB622EF0AECB4B81B3CDA62C1ACF1F32 () dell2
[Download RAW message or body]

Hi,

>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;

I'm creating a converter which converts Visual FoxPro expressions to 
Postgres at runtime.
FoxPro expression a+b  produces trailing spaces after a  .
To get same result I need to + or other operator with this behaviour.

Andrus. 



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]