Horton

Re: [HACKERS] SELECT BUG

Zeugswetter Andreas <andreas.zeugswetter@telecom.at>

View thread
From: Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
To: hackers@postgresql.org
Date: 1999-09-03T07:13:52Z
Lists: pgsql-hackers 
> This inconsistency bothers me: I've always thought that char(),
> varchar(), and text() are functionally interchangeable, but it seems
> that's not so.  Is this behavior mandated by SQL92?

Yes, the behavior is correct, and mandated by SQL92. 
A char would not be able to hold the information of how many trailing blanks
are user data, since it fills the column with trailing blanks.

Andreas