Andre Lopes <lopes80andre(at)gmail(dot)com> wrote:
> I need to return an Int4 when I do this king of select
> [code]
> select CURRENT_DATE - '2009-12-31' from tbl_sometable
> [/code]
> This select returns an Interval. How can I return an Integer? Like '138'
That expression returning an interval would be contradictory
to the documentation and a simple test:
| tim=# SELECT CURRENT_DATE - '2009-12-31';
| ?column?
| ----------
| 138
| (1 Zeile)
| tim=# SELECT CURRENT_DATE::TIMESTAMP - '2009-12-31';
| ?column?
| ----------
| 138 days
| (1 Zeile)
| tim=#
So how far away from "this kind of select" is your actual
query?
Tim