public inbox for [email protected]  
help / color / mirror / Atom feed
From: Adrian Klaver <[email protected]>
To: Alexander Farber <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?
Date: Sat, 18 Jan 2025 08:06:29 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAADeyWgSH+0amMokkijRXyOfFW88-QRw8CzOfjZNW89MCJZNMw@mail.gmail.com>
References: <CAADeyWjuNpncDm=pEQfOpLOgc_EQnd6B9sKfxQT8zGKJufcjeQ@mail.gmail.com>
	<CAFePLY0G3UmzdbfdJs5Ngdo4GoQKpSW2okfp00hvpm-HBkGYRQ@mail.gmail.com>
	<CAADeyWgSH+0amMokkijRXyOfFW88-QRw8CzOfjZNW89MCJZNMw@mail.gmail.com>

On 1/18/25 06:04, Alexander Farber wrote:
> Thank you Giovanni, I did not expect this from NOW() and that is why I 
> was stuck.

FYI, it is explained here:

https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT



-- 
Adrian Klaver
[email protected]







view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox