Re: serial data type

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Tom Allison <tallison(at)tacocat(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: serial data type
Date: 2004-09-25 23:33:16
Message-ID: 87y8ixq5z7.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Allison <tallison(at)tacocat(dot)net> writes:

> Doug McNaught wrote:
>>>Is it realistic to use the serial data type as a KEY?
>> Lots and lots of people do. If you're just looking for a unique key
>> column for a single table, it works fine.
>> -Doug
>
> This is essentially what I'm looking for.
>
> Any idea how to set up a timestamp=now on every insert/update ?

Use a trigger.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Healy 2004-09-26 00:01:33 Re: serial data type
Previous Message Tom Allison 2004-09-25 23:20:23 Re: serial data type