> Maybe doesn't help overall but this can be equivalently written as:
s + '1 day'::interval as period_end
Ah, so I've glossed over a detail here which is that I'm relying on some
timezone specific behavior and not actually generate_series itself. If
you're curious, the details are here:
On Wed, Nov 8, 2023 at 6:26 PM Lincoln Swaine-Moore
wrote:
> SELECT
>
s at time zone 'utc' AS period_start,
> LEAD(s) OVER (
> ORDER BY
> s
> ) at time zone 'utc' AS period_end
>
Maybe
Hi all--
I'm having a performance problem in 12.16 that I'm hoping someone can help
with.
I have a table shaped roughly like this:
Table "public.data"
Column |Type | Collation | Nullable |
Default
On Mon, 6 Nov 2023 at 09:59, Jose Osinde wrote:
>
> Dear all,
>
> I'm running a query from Java on a postgres database:
>
> Java version: 17
> JDBC version: 42.4.2
> Postgres version: 13.1
>
> In parallel I'm testing the same queries from pgAdmin 4 version 6.13
>
> The tables I'm using contains
