In my experience trying to keep the Oracle and PG code to look as much like each other as possible, it's easier to keep the integer day different paradigm rather than use interval this way.
When I've written PG-only stuff I've always used the interval notation, however.
