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

From codeWarrior
Subject Re: I was spoiled by the MySQL timestamp field
Date
Msg-id b0oprn$310p$1@news.hub.org
Whole thread Raw
In response to I was spoiled by the MySQL timestamp field  ("Alan T. Miller" <amiller@hollywood101.com>)
List pgsql-general
postgreSQL actually has a better implementation of timestamps.... In
mySQL -- You can have only 1 timestamp field...

In postgreSQL -- you can have as many  "create_dt" timestamp default 'now()'
fields as you want and on an insert -- they ALL get stamped whereas in
mySQL --ONLY 1 COLUMN gets updated....



""Alan T. Miller"" <amiller@hollywood101.com> wrote in message
news:003a01c2c2da$a90d10a0$6e01a8c0@webdev...
> As someone who is just getting started with PostygreSQL from years working
> with MySQL, it appears that the timestamp data type does not behave in the
> way it did with MySQL. I got used to just defining a column as a timestamp
> and letting the database throw the latest time stamp in there whenever a
row
> was updated. Is there anything simular in PosgreSQL? How can I accomplish
> something simular inside the database, or am I stuck populating the field
in
> some manner as in the following example
>
> update blah blah blah timestamp = NOW()
>
> Thanks,
>
> Alan
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



pgsql-general by date:

Previous
From: "Matthew Nuzum"
Date:
Subject: Re: I was spoiled by the MySQL timestamp field
Next
From: Richard Lukacik
Date:
Subject: Inquiry From Form [pgsql]