Re: serial data type - Mailing list pgsql-general

From Doug McNaught
Subject Re: serial data type
Date
Msg-id 87y8ixq5z7.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: serial data type  (Tom Allison <tallison@tacocat.net>)
List pgsql-general
Tom Allison <tallison@tacocat.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

pgsql-general by date:

Previous
From: Tom Allison
Date:
Subject: Re: serial data type
Next
From: gearond@fireserve.net
Date:
Subject: IN or JOIN