Re: I was spoiled by the MySQL timestamp field - Mailing list pgsql-general

From Tom Lane
Subject Re: I was spoiled by the MySQL timestamp field
Date
Msg-id 19434.1043641252@sss.pgh.pa.us
Whole thread Raw
In response to Re: I was spoiled by the MySQL timestamp field  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> At 05:00 PM 1/26/03 -0500, Tom Lane wrote:
>> (BTW, the reason 'now' without "timestamp" in front works is that this
>> is not a timestamp literal but a text literal, which will be coerced
>> to timestamp at runtime.)

> Is it known at the moment which of those methods the Postgresql team are
> aiming to continue supporting for the near/medium future?

AFAIK there are no plans to break any of them; though certainly
CURRENT_TIMESTAMP is the most future-proof, being spec-mandated.

            regards, tom lane

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: I was spoiled by the MySQL timestamp field
Next
From: Bruce Momjian
Date:
Subject: Re: When to Vacuum