On Monday 07 May 2007 3:19 pm, Rich Shepard wrote: > On Mon, 7 May 2007, Tom Lane wrote: > > It might be that converting those columns to interval is the best answer, > > depending on what other processing needs to be done with them. But if > > Rich wants to leave them as numbers, the above is the best way to convert > > them to intervals on-the-fly. > > Columns 'term' and 'process_time' converted to intervals. Just to > confirm my understanding of today's lesson: > > SELECT permit_nbr, title, date_issued, term, process_time from Permits > WHERE date_issued + term) < (CURRENT_DATE + process_time + '2 > week'::INTERVAL); > > is now correct syntax and use? > > Thanks all, > > Rich Yes. -- Adrian Klaver aklaver@xxxxxxxxxxx
