getting at the actual int4 value of an abstime

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 ]

Responses

Browse pgsql-general by date

  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 ?

Browse pgsql-hackers by date

  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?