Re: Multifunction Indexes

From: David Wheeler <david(at)kineticode(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: <sfpug(at)postgresql(dot)org>
Subject: Re: Multifunction Indexes
Date: 2003-03-15 01:28:48
Message-ID: 78D24663-5685-11D7-8FDF-0003931A964A@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

On Friday, March 14, 2003, at 04:43 PM, Stephan Szabo wrote:

> sszabo=# select lower(a) || to_char(b, '09999999999') from test;
> ?column?
> ----------------
> a 00000000123
> a1 00000000023
> (2 rows)
>
> (I guess you might really want FM0... but...)

FMO?

Thanks for the help!

David

--
David Wheeler AIM: dwTheory
david(at)kineticode(dot)com ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
Kineticode. Setting knowledge in motion.[sm]

In response to

Responses

Browse sfpug by date

  From Date Subject
Next Message David Wheeler 2003-03-15 01:31:32 Re: Multifunction Indexes
Previous Message elein 2003-03-15 01:20:05 Re: Multifunction Indexes