Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?
Date: 2025-01-18 16:06:29
Message-ID: a645a79c-6f72-4f78-b711-67726e2d8ca4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Schneider 2025-01-19 07:20:25 Re: glibc 2.35-2.39 upgrade requirements
Previous Message Alexander Farber 2025-01-18 14:04:07 Re: Why is DELETE FROM vehicle_data WHERE NOW, > expires_at, failing in my stored function?