On Thu, January 17, 2008 11:48, Scott Marlowe wrote: > Got bored, hacked this aggregious pl/pgsql routine up. It looks > horrible, but I wanted it to be able to use indexes. Seems to work. > Test has ~750k rows and returns in it and returns a new id in < 1ms > on my little server. > > File attached. > Many thanks. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@xxxxxxxxxxxxx Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
