Date storage class type

From: Daryl Sayers <daryl(at)coreng(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Date storage class type
Date: 2000-08-11 04:44:46
Message-ID: 200008110444.OAA14306@mippet.ci.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I sent this last night but I dont think it got through. Here it is again.
Sorry if its a duplicate.

-------------------------------------------------------------------------------
I think I have missed something obvious. I am writting my first postgresql
C program that accesses a table with a date field. I do the request using
a DECLARE BINARY CURSOR. I have a few floats/ints etc that I get
float *o;
int *v;

o = (float *)PQgetvalue(res, i, HIO);
v = (float *)PQgetvalue(res, i, HIV);

My problem is I cant seem to get a date back into a usable form. How do
I retrieve a date back using a binary cursor. What storage type does it
use?

--
Daryl Sayers
Corinthian Engineering Ph: (02) 9906 7866
Suite 19, 401 Pacific Hwy Fax: (02) 9906 1556
Artarmon, NSW, 2064 email: daryl(at)ci(dot)com(dot)au
Australia www: http://www.cordoors.com.au

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-08-11 05:42:15 Re: Postgres problems with large databases.
Previous Message Matthew 2000-08-11 00:07:25 RE: Windows 98