date - date returns integer?
| От | Andrew Hammond |
|---|---|
| Тема | date - date returns integer? |
| Дата | |
| Msg-id | 4228CC16.7020900@ca.afilias.info обсуждение |
| Ответы |
Re: date - date returns integer?
Re: date - date returns integer? |
| Список | pgsql-sql |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Should date - date return type integer, not interval?
/* ahammond@test:5432/test =# */ SELECT ('2005-03-04'::timestamp -
'2005-01-01'::date)::interval;
~ interval
- ----------
~ 62 days
(1 row)
/* ahammond@test:5432/test =# */ SELECT ('2005-03-04'::date -
'2005-01-01'::date)::interval;
ERROR: cannot cast type integer to interval
- --
Andrew Hammond 416-673-4138 ahammond@ca.afilias.info
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQFCKMwVgfzn5SevSpoRAlxAAJ9iPVf2yTNt11JBGc6Hun2s23+/MwCfYRwL
SzElfOrlIskOTAZucUdCeUE=
=jgOp
-----END PGP SIGNATURE-----
В списке pgsql-sql по дате отправления: