Re: [SQL] Help on indexing timestamps

2003-03-07 Thread Andre Schubert
On Fri, 7 Mar 2003 15:03:01 -0200 (GMT+2) Achilleus Mantzios <[EMAIL PROTECTED]> wrote: > On Fri, 7 Mar 2003, Andre Schubert wrote: > > > On Fri, 7 Mar 2003 14:17:36 -0200 (GMT+2) > > Achilleus Mantzios <[EMAIL PROTECTED]> wrote: > > > > > On Fri, 7 Mar 2003, Andre Schubert wrote: > > > > > > >

[SQL] Splitting text into rows with SQL

2003-03-07 Thread Chris Gamache
Using Postgresql 7.2.3 ... In order to search using indexes I need to split a composite field into its components and return it as rows... If this would only work: create table table_with_composite_fields ( data1 serial, data2 varchar(100), composite_field text ); insert into table_with_compos