On 12/14/21 10:00 AM, Sanjay Minni
wrote:
Its an insert and my insert SQL contains the column timestamp and value nil.Will it work if the SQL contains timestamp through value is nil
On Tue, 14 Dec, 2021, 9:20 pm Adrian Klaver, <adrian.klaver@xxxxxxxxxxx> wrote:
On 12/14/21 07:36, Sanjay Minni wrote:
> Hi
>
> I am not getting the timestamp value which i am expecting to be
> automatically inserted in the column defined:
> ...
> "timestamp" timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
> ...
> (I see the above definition in pgadmin4 in the tab SQL.
> I have set it thru pgadmin4 table->properties->columns by entering
> CURRENT_TIMESTAMP in the default column)
>
> why is the timestamp value not being automatically inserted by the system
1) It is a DEFAULT value so if a value is provided in the INSERT that
will be used.
2) DEFAULT values only apply to INSERTs not UPDATEs.
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
