Re: ODBC driver issue

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ODBC driver issue
Date: 2017-07-27 04:13:28
Message-ID: 5b02778e-4423-6f7d-a659-0e8602f890d1@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Samad 2017-07-27 05:08:39 Question about paritioning
Previous Message Igor Korot 2017-07-27 04:06:08 Re: ODBC driver issue