DEFAULT in update & prepared statements

From: Sanjay Minni <sanjay(dot)minni(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: DEFAULT in update & prepared statements
Date: 2023-11-08 16:02:16
Message-ID: CAMpxBo=M35hcH1g4Vg=KRJ0-77FOJcvdrdiVF5KSOAdOG-LvKQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Can DEFAULT (defined for a timestamp column as now() ) be used in
1. prepared statement i.e. EXECUTE ( ..., DEFAULT, ...)
2. in an UPDATE statement UPDATE TABLE SET update_time = DEFAULT ...

thanks
Sanjay

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2023-11-08 17:21:20 Re: DEFAULT in update & prepared statements
Previous Message Martin Norbäck Olivers 2023-10-29 16:31:07 Re: full text search and hyphens in uuid