Re: SET DATESTYLE to time_t style for client libraries?

I would suggest taking a look at the mxDateTime package if you want to
manipulate dates in Python.

Adam Haberlach <adam(at)newsnipple(dot)com> writes:

<snip>

>
> I'll look into getting it to ingest dates, but it seems
> wasteful to have the server take its internal reprentation,
> pretty-format it into a nice human-readable representation to send
> to the client, and then have the client parse that into something it
> can deal with internally. While it is a fairly minor performance
> issue, it seems there are a lot of chances for things to go wrong.

That's a good point. On the other hand, I trust the PostgreSQL folks
to know more about all of the wacky time edge cases than I do. I know
that I am not particular excited about using raw time_t values.

> I've already had to hack my python libs a bit to make the
> money type work correctly. It takes the incoming text, removes '$'
> and ',' and then tries to convert it into a float. In the case of
> negative values, it will blow up because there are "()" around the
> value. I'll submit a patch if anyone is interested.

Why not simply use the numeric type? I thought the money type was
deprecated.

> ...I assume that the ISO-8601 representation itself won't be
> changing, but time is silly and there's a lot of edge cases. It'd
> be nice to have a way to reliabily tell the server "Give me
> standardized raw values, I'll sort things out on my end." Of
> course, this may already be happening within the C libraries and I'm
> not seeing them inside python. I'll look around a bit more.

mxDateTime is your friend.

Jason