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,

[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 properties_