Postgres Pro
Downloads
Home   >   mailing lists

Re: CHAR LIKE VARCHAR - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: CHAR LIKE VARCHAR
Date
Msg-id EA3FA6C1-9747-4D3C-97CE-A930CE00F111@myrealbox.com
Whole thread Raw
In response to Re: CHAR LIKE VARCHAR  (Richard Huxton <dev@archonet.com>)
Responses Re: CHAR LIKE VARCHAR
List pgsql-general
Tree view 
On Jun 7, 2005, at 6:03 PM, Richard Huxton wrote:

> If you ask me (and it's too late to back out now :-) the whole
> behaviour of CHAR(n) is wrong, broken and just a bad idea.

Just a quick addition: AFAIK, this bad, broken behavior (I definitely
agree!) is per SQL spec.  :( Don't know about the LIKE operator,
however.

Michael Glaesemann
grzm myrealbox com

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: CHAR LIKE VARCHAR
Next
From: Phil Endecott
Date:
Subject: Re: CPU-intensive autovacuuming