Re: char(0)

On 17.10.2011 10:30, Simon Riggs wrote:
> On Mon, Oct 17, 2011 at 8:31 AM, Susanne Ebrecht
> <susanne@2ndquadrant.com>  wrote:
>
>> PostgreSQL isn't supporting CHAR(0).
> What does the SQL Standard say?
>

Document: 02-Foundation

Section: 4.2.1 Introduction to character strings

Begin quoting
A character string is a sequence of characters. All the characters in a 
character string are taken from a single
character set. A character string has a length, which is the number of 
characters in the sequence. The length is
0 (zero) or a positive integer.
End quoting

-- 
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com