Hi,
I hale a problem with counting interwal and I can't find what to do with
this.
I have two fields in the table:
Column | Type | Modifiers
-----------------+---------+-----------
date_in | date |
interwal_months | numeric |
-----------------+---------+-----------
Query
SELECT date_in + INTERVAL '3 MONTH' FROM any_table
works fine of course.
However, how to do something like that?
SELECT date_in + INTERVAL ' interwal_months MONTH' FROM any_table
I hope I'm just blind.. ;-)
Thanks for any help.
MK
---------------------------(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
