Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 5715D633228
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 18 Jul 2009 07:25:19 -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 01887-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 18 Jul 2009 07:25:02 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158])
	by mail.postgresql.org (Postfix) with ESMTP id 5F21F633F04
	for <pgsql-sql@postgresql.org>; Sat, 18 Jul 2009 07:25:08 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 13so256874fge.0
	for <pgsql-sql@postgresql.org>; Sat, 18 Jul 2009 03:25:06 -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:content-type;
	bh=+lDRhJdoJtkP+AV6u9lux7fTYRJFe0gLqYo8vnTOwFs=;
	b=ZwJ0N20274/yharxeiVJ/3tC/pagDZG73GFFj2T/S6QxBUdi8wvZuKHh8vuEKSppHa
	6iewbX1+/uiHAIG3EZCb460kWIQsYWrOATDlc7KPQ0LqES3PowylfE1SwGPcYxoxvyQj
	gZxjlYwfZd0+sqsdbtV3222AaEOUAr2ye4Z1I=
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
	:content-type;
	b=s7FGEY80lCqG/7VoIztkz0hGpW64d6CbT8dIMosqFDENU2rWAWjX5cSxJ1NNj0Saa9
	4Ug+0MaAZje533cJiH42qgRoD+I2BIMalyjWjEhVAYQkAnLv7YHzZ5sgOGB1l3b2QDHE
	OBcKHk/RLwZlSss8QoW8IXs6R+zicP35ak3kU=
MIME-Version: 1.0
Received: by 10.86.98.18 with SMTP id v18mr1650982fgb.13.1247912706341; Sat,
	18 Jul 2009 03:25:06 -0700 (PDT)
In-Reply-To: <24F73F01AD1B4036A4C3F461ED6759CE@PCGianvito>
References: <24F73F01AD1B4036A4C3F461ED6759CE@PCGianvito>
Date: Sat, 18 Jul 2009 12:25:06 +0200
Message-ID: <a0eee4d40907180325s2ac61859g71de0746825c28e2@mail.gmail.com>
Subject: Re: Timestamp with timezone with Default value
From: Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>
To: Gianvito Pio <pio.gianvito@gmail.com>, pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=000e0cd25dc0927a8f046ef851a9
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/80
X-Sequence-Number: 32821

--000e0cd25dc0927a8f046ef851a9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

i think:
create. ...(

  myCol timestamp with timezone default now()
)
the function now() returns a timestamp with timezone (
http://www.postgresql.org/docs/8.4/static/functions-datetime.html)

i currently have no db to test it - but it should work.

jasmin
2009/7/18 Gianvito Pio <pio.gianvito@gmail.com>

>  Hi all,
> how can I define a column of timestamp with timezone type...with a defaul=
t
> value?
>
> Thanks
>
>



--=20
Mit freundlichen Gr=FC=DFen

Dizdarevic Jasmin
Sonnenbergstr. 3
6714 N=FCziders, AUT

jasmin.dizdarevic@gmail.com
+43 664 411 79 29

--000e0cd25dc0927a8f046ef851a9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi, </div>
<div>=A0</div>
<div>i think: </div>
<div>create. ...(</div>
<div>=A0</div>
<div>=A0 myCol timestamp with=A0timezone=A0default now()</div>
<div>)<br></div>
<div>the function now() returns a timestamp with timezone (<a href=3D"http:=
//www.postgresql.org/docs/8.4/static/functions-datetime.html">http://www.po=
stgresql.org/docs/8.4/static/functions-datetime.html</a>)</div>
<div>=A0</div>
<div>i currently have no db to test it - but it should work.</div>
<div>=A0</div>
<div>jasmin<br></div>
<div class=3D"gmail_quote">2009/7/18 Gianvito Pio <span dir=3D"ltr">&lt;<a =
href=3D"mailto:pio.gianvito@gmail.com">pio.gianvito@gmail.com</a>&gt;</span=
><br>
<blockquote style=3D"BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex=
; PADDING-LEFT: 1ex" class=3D"gmail_quote">
<div bgcolor=3D"#e1e1e3">
<div><font size=3D"2" face=3D"Arial">Hi all,</font></div>
<div><font size=3D"2" face=3D"Arial">how can I define a column of timestamp=
 with timezone type...with a default value?</font></div>
<div><font size=3D"2" face=3D"Arial"></font>=A0</div>
<div><font size=3D"2" face=3D"Arial">Thanks</font></div>
<div><font size=3D"2" face=3D"Arial"></font>=A0</div></div></blockquote></d=
iv><br><br clear=3D"all">
<div></div><br>-- <br>Mit freundlichen Gr=FC=DFen<br><br>Dizdarevic Jasmin<=
br>Sonnenbergstr. 3<br>6714 N=FCziders, AUT<br><br><a href=3D"mailto:jasmin=
.dizdarevic@gmail.com">jasmin.dizdarevic@gmail.com</a><br>+43 664 411 79 29=
<br>
<br>

--000e0cd25dc0927a8f046ef851a9--