Re: [GENERAL] 'a' == 'a ' - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] 'a' == 'a '
Date
Msg-id 14453.1129845234@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] 'a' == 'a '  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: [GENERAL] 'a' == 'a '
List pgsql-hackers
"Dann Corbit" <DCorbit@connx.com> writes:
> I guess that additional ambiguity arises if you add additional spaces to
> the end.  Many database systems solve this by trimming the characters
> from the end of the string upon storage and the returned string will not
> have any trailing blanks.

Can you document that?  ISTM that that would effectively make char(n)
and varchar(n) exactly equivalent, which is ... um ... a bit stupid.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] 'a' == 'a '
Next
From: Simon Riggs
Date:
Subject: Re: Spinlocks, yet again: analysis and proposed patches