Re: [SQL] psql connection being reset during function?

2001-08-15 Thread Randall Skelton
Excellent! The function you suggest is certainly a better approach... 5 minutes of processing and it was done. Thanks Tom. Cheers, Randall On Tue, 14 Aug 2001, Tom Lane wrote: > Randall Skelton <[EMAIL PROTECTED]> writes: > > problem #2: While this works perfectly for a sm

[SQL] psql connection being reset during function?

2001-08-14 Thread Randall Skelton
Hi all, I am running 7.1.2 and I have the unenviable task of cleaning up a database which has columns: sgmty integer, -- YEAR sgmtmo integer, -- MONTH sgmtd integer, -- DAY sgmth integer, -- HOUR sgmtm integer, -- MINUTE sgmts float, -- SECOND + 190 other floats per row The d