Re: [HACKERS] qsort again (was Re: Strange Create Index

Markus Schaber <schabi@logix-tt.com>

From: Markus Schaber <schabi@logix-tt.com>
To: PFC <lists@peufeu.com>
Cc: pgsql-performance@postgresql.org
Date: 2006-02-17T00:18:06Z
Lists: pgsql-hackers, pgsql-performance
Hi, PFC,

PFC schrieb:

>     By the way, I'd like to declare my zipcode columns as SQL_ASCII
> while the  rest of my database is in UNICODE, so they are faster to
> index and sort.  Come on, MySQL does it...

Another use case for parametric column definitions - charset definitions
- and the first one that cannot be emulated via constraints.

Other use cases I remember were range definitions for numbers or PostGIS
dimension, subtype and SRID, but those cann all be emulated via checks /
constraints.

Markus