Forum OpenACS Q&A: postgres-pgtcl.sql --> Is it meant to be commented out in load-data-model.sql?
checked out of CVS a couple of days ago and had some problems with
the function months_between(). I found the declaration in postgres-
pgtcl.sql, checked my DB in postgres and found that the function
hadn't been created. Checked the load-data-model.sql script which I
used to load the DB and found that the file had been commented out.
Is this meant to be the case??
In other words, today's June 16th.
months_between(today, may 1) is one month.
Is months between(today, may 17th) one month or zero months? (i.e. does it truncate to the month then determine the interval?)
This routine's easy to implement in PL/pgSQL and I'll check one in if someone can tell me the exact semantics.
I think I can emulate this well enough for the ACS, which only uses the integer portion. I tried test cases for various lengthed months and the fractional part returned by Oracle is kinky (days left over/31?)