Re: [SQL] metaphone and nysiis in postgres

2007-02-08 Thread Jan Muszynski
On 8 Feb 2007 at 10:59, Demel, Jeff wrote: > I don't have a problem with doing this in our development environment, > but when we go to move it onto the live production box, with all the > live data and current custom settings, will a re-install cause issues? > Data loss is unacceptable, of course

Re: [SQL] interval as hours or minutes ?

2007-02-07 Thread Jan Muszynski
On 7 Feb 2007 at 19:03, Aarni Ruuhimäki wrote: > Hi all, > > Could anyone please tell an easy way to get total hours or minutes from an > interval ? > > SELECT SUM(stop_date_time - start_date_time) AS tot_time FROM work_times WHERE > user_id = 1; > tot_time > - > 2 days 14:08: