Re: "posttime" time DEFAULT now() - Mailing list pgsql-sql

From Koen Antonissen
Subject Re: "posttime" time DEFAULT now()
Date
Msg-id DD782DD61CF86144BD78DDC89D3D6124017085@gaea.home.dutchcentral.net
Whole thread Raw
In response to "posttime" time DEFAULT now()  ("Koen Antonissen" <Koen@Cee-Kay.net>)
List pgsql-sql
I had our sysadmin reinstall 7.1 again, we were in a hurry. Thanks for
the hint though!

Koen Antonissen

-----Original Message-----
From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au]
Sent: vrijdag 23 november 2001 2:42
To: Koen Antonissen; pgsql-sql@postgresql.org
Subject: RE: [SQL] "posttime" time DEFAULT now()


Try making it: "posttime" time DEFAULT 'CURRENT_TIME';

Chris

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Koen Antonissen
> Sent: Thursday, 22 November 2001 9:30 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] "posttime" time DEFAULT now()
> 
> 
> Hi
> 
> "posttime" time DEFAULT now()
> 
> I'm declaring a field called posttime (see above), which ofcourse
stores
> the time of a certain posting. It's nice to use a default value as
> now(). But unfourtunatly, while creating the table, it generates the
> following error:
> 
> ERROR:  Column "posttime" is of type time without time zone but
default
> expression is of type timestamp with time zone
>         You will need to rewrite or cast the expression
> 
> I prefer to ignore the timezone information... any hints?
> 
> NOTE: I've updated from 7.1 to 7.2b2 and before there was no problem
> like this (exact same table existed on 7.1).
> 
> 
> Thanks,
> Koen Antonissen
> 
> ---------------------------(end of
broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
> 



pgsql-sql by date:

Previous
From: Dino Cherian
Date:
Subject: Re: How to return more than one row of data from a function in PL/pgSQL
Next
From: "Johnny J\xF8rgensen"
Date:
Subject: Re: How to return more than one row of data from a