Bug in concat operator for Char?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: glenniii(at)mail(dot)utexas(dot)edu
Subject: Bug in concat operator for Char?
Date: 2004-07-20 18:00:53
Message-ID: 200407201100.53238.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

People,

Severity: Serious Annoyance
Reproducable on: 7.4.1, 7.4.3, 7.5devel
Summary: Concatination of CHAR() data type field seems to result in a TEXT
value instead of a CHAR value. Is there a reason for this?

Example:
webmergers=> select '"'::char(4) || ''::char(4) || '"'::char(4);
?column?
----------
""
(1 row)

Depending on the spec, it seems to me that the above should result either in a
char(4) of " " or a char(12) of " " . But we get a text value.
Is this the SQL spec? Is there another reason for this behavior?

--
-Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2004-07-20 18:06:27 Re: Bug in concat operator for Char? -- More Info
Previous Message Peter Eisentraut 2004-07-20 16:17:34 Re: BUG #1198: Linux PostgreSQL Server Input Validation Vulnerability