I'm sure this has been asked before, but I couldn't find it:
I have a "zzz CHAR (8)" field. It needs to be CHAR because trailing
spaces need to be ignored for most operations. However, I need to
concatenate it with another (literal) string and need the spaces to be
significant in that operation. The *ONLY WAY* I could find to do it in
v9.0.1 was (represented in the following function):
CREATE OR REPLACE FUNCTION padded( field CHAR ) RETURNS TEXT
RETURNS NULL ON NULL INPUT
IMMUTABLE
LANGUAGE SQL AS $SQL$
SELECT RPAD( $1, OCTET_LENGTH( $1 ) )
$SQL$;
And then of course I write:
SELECT padded( zzz ) || '/' || ...
Is there a better way?