raf writes:
> Q1) if an integer cannot be explicitly cast into an interval, what is
> happening
> when a date difference is stored in an interval variable to allow it to
> happen?
plpgsql is really lax about type coercions. It typically does them by
converting the source value to text and then
hi,
postgresql-9.1.3
the difference between two dates is an integral
number of days as demonstrated by:
select select date '2012-08-03' - date '2012-08-01';
?column?
--
2
i just noticed that i had some (buggy) code that
stored the differe
