Re: [GENERAL] ODBC driver issue - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] ODBC driver issue
Date
Msg-id 5b02778e-4423-6f7d-a659-0e8602f890d1@hogranch.com
Whole thread Raw
In response to Re: [GENERAL] ODBC driver issue  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: [GENERAL] ODBC driver issue
Next
From: Alex Samad
Date:
Subject: [GENERAL] Question about paritioning