> I think you may want to change your query to:
>
> select date_part(datetime(abst_att), 'epoch') ....
>
> In addition, unless you were using BINARY cursor, you will need to do
> something like:
>
> time_t t = atol(PQgetvalue(res, i, 0));
I have tried this but don't think I understand the internal datetime
function correctly. Should my query be(start is defined as abstime):
select start(datetime(abst_att),'epoch') from timebase;
And then should this work:
printf("%lu\n",(unsigned long)PGgetvalue(res,0,0));
Thanks for your help.
--
Colin Dick
On Call Internet Services
cdick(at)mail(dot)ocis(dot)net