agora inbox for pgsql-interfaces@postgresql.org  

help / color / mirror / Atom feed

From: Neeraj Rai <rneeraj@yahoo.com>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
To: Neeraj Rai <rneeraj@yahoo.com>
Subject: Re: - pgaql binary data date time fornats
Date: Wed, 22 May 2013 09:52:10 -0700 (PDT)
Message-ID: <1369241530.69063.YahooMailAndroidMobile@web164901.mail.bf1.yahoo.com> (raw)
In-Reply-To: <1369185968.87888.YahooMailNeo@web164906.mail.bf1.yahoo.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-interfaces>

Hi,

I forgot to mention that I'm trying to use binary data format.
I found exanples of sending string fornatted date time. However, i am assuming there are functions to covert unix time to pgtimestamptz and may be faster
Looking for inverse of ts.epoch

I can bypass bitwise fueld issue by assigning to int.
I think Q5 can be ignored. It should work the same for execparams and execprepared.

Thanks
Neeraj

Message-ID: <1369241530.69063.YahooMailAndroidMobile@web164901.mail.bf1.yahoo.com>
Permalink:  ../1369241530.69063.YahooMailAndroidMobile@web164901.mail.bf1.yahoo.com/
Also on:    postgresql.org/message-id/1369241530.69063.YahooMailAndroidMobile@web164901.mail.bf1.yahoo.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: rneeraj@yahoo.com
  Subject: Re: - pgaql binary data date time fornats
  In-Reply-To: <1369241530.69063.YahooMailAndroidMobile@web164901.mail.bf1.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox