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

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Markus Schaber <schabi(at)logix-tt(dot)com>, pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: qsort again (was Re: [PERFORM] Strange Create Index
Date: 2006-02-16 23:23:09
Message-ID: 1140132189.9076.261.camel@archimedes
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Thu, 2006-02-16 at 17:51 -0500, Greg Stark wrote:
> > > Data types which could probably provide a useful function for f would be
> > > int2, int4, oid, and possibly int8 and text (at least for SQL_ASCII).
>
> How exactly do you imagine doing this for text?
>
> I could see doing it for char(n)/varchar(n) where n<=4 in SQL_ASCII though.

In SQL_ASCII, just take the first 4 characters (or 8, if using a 64-bit
sortKey as elsewhere suggested). The sorting key doesn't need to be a
one-to-one mapping.

-- Mark Lewis

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Luke Lonergan 2006-02-16 23:35:48 Re: In Japan with Josh Berkus
Previous Message PFC 2006-02-16 23:05:23 Re: [HACKERS] qsort again (was Re: Strange Create Index

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schaber 2006-02-17 00:18:06 Re: [HACKERS] qsort again (was Re: Strange Create Index
Previous Message PFC 2006-02-16 23:05:23 Re: [HACKERS] qsort again (was Re: Strange Create Index