On 11 Nov 2003, Greg Stark wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > > On Tue, 11 Nov 2003, Greg Stark wrote: > > > > > Actually you might be able to get the same effect using function indexes > > > like: > > > > > > create index i on traffic_log (month_trunc(runtime), company_id) > > > > had actually thought of that one ... is it something that is only > > available in v7.4? > > Hum, I thought you could do simple functional indexes like that in 7.3, but > perhaps only single-column indexes. > > In any case, given your situation I would seriously consider putting a > "month" integer column on your table anyways. Then your index would be a > simple (month, company_id) index.
In 7.3 and before, you had to use only column names as inputs, so you could cheat: alter table test add alp int; alter table test add omg int; update test set alp=0; update test set omg=13; and then create a functional index: create index test_xy on test (substr(info,alp,omg)); select * from test where substr(info,alp,omg)=='abcd'; ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster