06/11/04 01:45:34
>>552
「3日たったてる」の箇所が曖昧だが、さっき（11/04）試したら
test=# select * from sns_message;
message_id | m_to | m_from | insert | status
------------+------+--------+---------------------+--------
1 | 111 | 555 | 2006-11-04 00:00:00 | 1
2 | 111 | 555 | 2006-11-03 00:00:00 | 1
3 | 111 | 444 | 2006-09-11 00:00:00 | 1
4 | 111 | 333 | 2006-11-07 00:00:00 | 1
5 | 111 | 333 | 2006-11-08 00:00:00 | 1
(5 rows)
test=# select * from sns_message where insert > current_timestamp + '3 day';
message_id | m_to | m_from | insert | status
------------+------+--------+---------------------+--------
5 | 111 | 333 | 2006-11-08 00:00:00 | 1
(1 row)
となっていますが、何か問題あり？