How to return an Int4 when subtracting dates/timestamps

Andre Lopes <lopes80andre@gmail.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