Re: [BUGS] char(0)

2011-10-18 Thread Tom Lane
Susanne Ebrecht writes: > On 17.10.2011 16:41, Andreas Pflug wrote: >> 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"? >> Sounds much too straight forward, not mysql-ish artistic enough... > Depend

Re: [BUGS] char(0)

2011-10-18 Thread Susanne Ebrecht
On 17.10.2011 16:41, Andreas Pflug wrote: Am 17.10.11 10:53, schrieb Thomas Kellerer: 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 e

Re: [BUGS] char(0)

2011-10-17 Thread PostgreSQL - Hans-Jürgen Schönig
On Oct 17, 2011, at 4:41 PM, Andreas Pflug wrote: > Am 17.10.11 10:53, schrieb Thomas Kellerer: >> 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. >

Re: [BUGS] char(0)

2011-10-17 Thread John R Pierce
On 10/17/11 7:41 AM, Andreas Pflug wrote: Sounds much too straight forward, not mysql-ish autistic enough... I fixed your spelling. HTH! -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-bugs mailing list (pgsql-

Re: [BUGS] char(0)

2011-10-17 Thread Andreas Pflug
Am 17.10.11 10:53, schrieb Thomas Kellerer: > 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

Re: [BUGS] char(0)

2011-10-17 Thread Susanne Ebrecht
Hello, On 17.10.2011 15:44, Boszormenyi Zoltan wrote: 2011-10-17 14:28 keltezéssel, Susanne Ebrecht írta: On 17.10.2011 10:30, Simon Riggs wrote: On Mon, Oct 17, 2011 at 8:31 AM, Susanne Ebrecht wrote: PostgreSQL isn't supporting CHAR(0). What does the SQL Standard say? Document: 02-Fou

Re: [BUGS] char(0)

2011-10-17 Thread Boszormenyi Zoltan
2011-10-17 14:28 keltezéssel, Susanne Ebrecht írta: On 17.10.2011 10:30, Simon Riggs wrote: On Mon, Oct 17, 2011 at 8:31 AM, Susanne Ebrecht wrote: PostgreSQL isn't supporting CHAR(0). What does the SQL Standard say? Document: 02-Foundation Section: 4.2.1 Introduction to character string

Re: [BUGS] char(0)

2011-10-17 Thread Susanne Ebrecht
On 17.10.2011 10:30, Simon Riggs wrote: On Mon, Oct 17, 2011 at 8:31 AM, Susanne Ebrecht 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

Re: [BUGS] char(0)

2011-10-17 Thread Thomas Kellerer
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).

Re: [BUGS] char(0)

2011-10-17 Thread Simon Riggs
On Mon, Oct 17, 2011 at 8:31 AM, Susanne Ebrecht wrote: > PostgreSQL isn't supporting CHAR(0). What does the SQL Standard say? --  Simon Riggs   http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-b

Re: [BUGS] char(0)

2011-10-17 Thread PostgreSQL - Hans-Jürgen Schönig
On Oct 17, 2011, at 9:31 AM, Susanne Ebrecht wrote: > 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 simula

[BUGS] char(0)

2011-10-17 Thread Susanne Ebrecht
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 mi