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
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
