From: | jim(at)reptiles(dot)org (Jim Mercer) |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | getting at the actual int4 value of an abstime |
Date: | 1999-08-17 22:23:29 |
Message-ID: | m11Grdh-00080YC@mailbox.reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
i have a table which uses an abstime to store a time/date.
the data originates as unix time_t, which i convert to a string when inserting
the data into the table.
i do select's from the table with WHERE clauses that use the abstime stuff.
i want to get the results of a select as unix time_t, without having to use
the expensive mktime()/strptime() unix C calls.
is there a way to get the int4 value that postgres is storing raw for
abstime?
i'm working in C with libpq.
--
[ Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 1999-08-17 23:24:55 | Re: [HACKERS] getting at the actual int4 value of an abstime |
Previous Message | jeremy | 1999-08-17 19:47:04 | Re: [GENERAL] what is PgUpT ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 1999-08-17 23:24:55 | Re: [HACKERS] getting at the actual int4 value of an abstime |
Previous Message | Bruce Momjian | 1999-08-17 21:59:52 | Re: [HACKERS] "out of free buffers: time to abort" message? |