char(0)

From: Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: char(0)
Date: 2011-10-17 07:31:46
Message-ID: 4E9BD9E2.2010305@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Susanne

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

Responses

  • Re: char(0) at 2011-10-17 08:18:07 from PostgreSQL - Hans-Jürgen Schönig
  • Re: char(0) at 2011-10-17 08:30:40 from Simon Riggs
  • Re: char(0) at 2011-10-17 08:53:30 from Thomas Kellerer

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL - Hans-Jürgen Schönig 2011-10-17 08:18:07 Re: char(0)
Previous Message Sachin Srivastava 2011-10-17 07:31:29 Re: BUG #6255: Unable to Install (Binary, One Click Installer