Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3E4C9633DAF
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 18 Jul 2009 05:20:10 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 72712-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 18 Jul 2009 05:19:59 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25])
	by mail.postgresql.org (Postfix) with ESMTP id 8B9C8633B43
	for <pgsql-sql@postgresql.org>; Sat, 18 Jul 2009 05:19:59 -0300 (ADT)
Received: by ey-out-2122.google.com with SMTP id 22so248225eye.61
	for <pgsql-sql@postgresql.org>; Sat, 18 Jul 2009 01:19:57 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:from:to:subject
	:date:mime-version:content-type:x-priority:x-msmail-priority
	:x-mailer:x-mimeole;
	bh=H+d5LOamOSa2vjNlGZp7MhCA6OZDGd+vSxNq73LWHxk=;
	b=pjB9VAvxivYaEoBtDwXu4E2T744FFxwWwN4XA6MeYTMZ8EYKS3p5D38c1CJnjCXftl
	mVa6NHdIzlVYXrsHMRaUW8U/mOyslOUnapcuoEgWJxnUodAXdyNfc11DGKDSyo/mg5Nh
	X87L0ojBsahgLu/hRsJfZyBOVahqgdTLAdLiI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:from:to:subject:date:mime-version:content-type
	:x-priority:x-msmail-priority:x-mailer:x-mimeole;
	b=aLsHgZCKpQ/E4VJAzTFwxG/FYba2f6zB6wa4sItr1/md8C+R1jQWIumQC9IbxkgiSm
	fgvdpP6Giwzm/BXatEYM7DbGa4afj8h45FVWXd9F/tvXuVICNW2jsU7FQdsLI/mi/9l9
	H92/Tm9oeNsmZUG6Vj2romxLhFtDtetCl2DCw=
Received: by 10.216.16.212 with SMTP id h62mr558105weh.201.1247905197858;
	Sat, 18 Jul 2009 01:19:57 -0700 (PDT)
Received: from PCGianvito (net-93-144-128-52.t2.dsl.vodafone.it
	[93.144.128.52])
	by mx.google.com with ESMTPS id f13sm5918562gvd.23.2009.07.18.01.19.55
	(version=SSLv3 cipher=RC4-MD5); Sat, 18 Jul 2009 01:19:56 -0700 (PDT)
Message-ID: <24F73F01AD1B4036A4C3F461ED6759CE@PCGianvito>
From: "Gianvito Pio" <pio.gianvito@gmail.com>
To: <pgsql-sql@postgresql.org>
Subject: Timestamp with timezone with Default value
Date: Sat, 18 Jul 2009 10:19:52 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0017_01CA0791.49E30EB0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200907/79
X-Sequence-Number: 32820

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01CA0791.49E30EB0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,
how can I define a column of timestamp with timezone type...with a =
default value?

Thanks

------=_NextPart_000_0017_01CA0791.49E30EB0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18783">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#e1e1e3>
<DIV><FONT size=3D2 face=3DArial>Hi all,</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial>how can I define a column of timestamp =
with=20
timezone type...with a default value?</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2 face=3DArial>Thanks</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0017_01CA0791.49E30EB0--