On 7/26/2017 9:06 PM, Igor Korot wrote:
With the char(), is there a "Standard SQL" way to do trimming?


trim(trailing from fieldname)


but really, if you want a variable length string without padding, don't use CHAR() as a data type. use VARCHAR or TEXT.


--
john r pierce, recycling bits in santa cruz



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

Reply via email to