The date_fields table

date_fields is used to store the date of all messages.

A date is stored as a native PostgreSQL timestamp. Archiveopteryx converts back and forth between SQL and email formats as needed. 


create table date_fields (
    -- Grant: select, insert
    message     integer not null references messages(id)
                on delete cascade,
    value       timestamp with time zone
);

The date_fields table was introduced in version 1.08.

In case of questions, please write to info@oryx.com.

Relevant links

About this page

Last modified: 2008-08-25
Location: aox.org/db/date_fields