Re: Re: why unsigned numbers don't exist ?

Fri, Jun 08, 2001 at 06:20, Peter Eisentraut wrote:
> Julien Jehannet writes:
>
> > Well, this is my true problem:
> > I have converted my date format into the unix time
>
> Why?  There's a DATE type.

Yes, I know. I'm using the TIMESTAMP type before but there exists some few
problems with the JDBC driver.
I read that new PostgreSQL can manage the Unix format but I'm sure that is more
efficient to test just a difference of seconds (with 2 integers) than several casts with timestamps and call an
function.
(I have a lot of tests of this kind)

Am I wrong ?? Furthemore, my applications must access to the Unix time format.
In your opinion, what is the best solution, int8 or numeric ??


Sincerely,

jul

--
(work)    Julien.Jehannet at SecurityKeepers.com
(home)    jhanet at caramail.com
'Early to rise and early to bed makes a man healthy but socially dead.'
  Animaniacs, série burlesque américaine