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