[GENERAL] Creating index for convert text to integer

2009-08-26 Thread xaviergxf
Hi, How can i create a index to index all the fields that has the type INTEGER, in the following table: create type properties_types as enum('INTEGER', 'STRING', 'FLOAT'); create table properties_types( value text NOT NULL, value_type properties_types NOT NULL ); insert into

Re: [GENERAL] Creating index for convert text to integer

2009-08-26 Thread Sam Mason
On Wed, Aug 26, 2009 at 07:13:41AM -0700, xaviergxf wrote: How can i create a index to index all the fields that has the type INTEGER, in the following table: create type properties_types as enum('INTEGER', 'STRING', 'FLOAT'); create table properties_types( value text NOT NULL,