Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id ED439632C0C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 22 Oct 2009 20:26:49 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 54273-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 22 Oct 2009 23:26:32 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iw0-f182.google.com (mail-iw0-f182.google.com
	[209.85.223.182])
	by mail.postgresql.org (Postfix) with ESMTP id 32208632741
	for <pgsql-sql@postgresql.org>; Thu, 22 Oct 2009 20:26:39 -0300 (ADT)
Received: by iwn12 with SMTP id 12so4310532iwn.15
	for <pgsql-sql@postgresql.org>; Thu, 22 Oct 2009 16:26:37 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=o+ojOlUYXBH1b1Wz6HkOyr7Jscnbf8FhWRYudeIpG10=;
	b=pf10cFbGCmQDfykCW/BZQbe0DUYBYes05Dt59CYEzLTsvpWu89NUmBQTl9U7JyQgE1
	mB1LOvAn8kGBLtVcWaTZa2kIcT/hsLwmmBGbdxXg3uyz1ZlkKV7oNXWriQfMI4eWSd9c
	2/eNidY8hnCghOOWxh2ta++Ox6k/azP8y46ZU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=ZLgXHontIPaWXMgLaH9NtAs69ohPWbh4S56Fb3LjQdjt77gwqYvOH8X6Pv884djxzU
	rZ3bb6/Qc+qeV1/i0evU6C+g4fDA2pz2IDzJvH+BGU75cTKv60wdJNRhpvejXo9Z65tO
	voV0DRrpY5JrJENNrR0neyXOriNm0BG4eKlvM=
MIME-Version: 1.0
Received: by 10.231.26.131 with SMTP id e3mr2148849ibc.0.1256253997716; Thu,
	22 Oct 2009 16:26:37 -0700 (PDT)
In-Reply-To: <22431f1b0910221341l371b8303w9b3a525afa598d1@mail.gmail.com>
References: <22431f1b0910221341l371b8303w9b3a525afa598d1@mail.gmail.com>
Date: Thu, 22 Oct 2009 17:26:37 -0600
Message-ID: <dcc563d10910221626v1a8c385fw1caeef0934474103@mail.gmail.com>
Subject: Re: question about timestamp with tz
From: Scott Marlowe <scott.marlowe@gmail.com>
To: the6campbells <the6campbells@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.492 tagged_above=-10 required=5 tests=AWL=0.107,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200910/117
X-Sequence-Number: 33316

On Thu, Oct 22, 2009 at 2:41 PM, the6campbells <the6campbells@gmail.com> wrote:
> Question.. is there a way that I can get Postgres to return the tz as
> supplied on the insert statement

PostgreSQL converts the timezone to GMT and stores it with no offset,
then adds an offset based on the TZ of the client requesting it back
later.

If you want to store the offset you'll have to do it yourself.  Note
that offset does not necessarily = timezone...