Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

sfpug by date

Next:From: David WheelerDate: 2003-03-15 01:31:32
Subject: Re: Multifunction Indexes
Previous:From: eleinDate: 2003-03-15 01:20:05
Subject: Re: Multifunction Indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group