Re: char(0)
Thomas Kellerer <spam_eater@gmx.net>
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-bugs@postgresql.org
Date: 2011-10-17T08:53:30Z
Lists: pgsql-bugs
Susanne Ebrecht, 17.10.2011 09:31: > Hello, > > I couldn't find that somebody already mentioned it. > > PostgreSQL isn't supporting CHAR(0). > > An empty string has a length of 0. > > CHAR(0) can have two values: NULL and empty string. > > In MySQL it is very common to simulate not null boolean > by using CHAR(0). > > This is a little bit annoying on migration topics. While not move on to a cleaner approach during the migration and use a "boolean not null"? Thomas