I am trying to generate random serial numbers in PostgreSQL with some conditions. The numbers need to start with the same 3 letters, YAK. After YAK, there needs to be 8 random digits. I only need to do 10 iterations…
I have a postgres table with timestamp columns: start_datetime end_datetime duration id 2021-10-17 03:13:00 2021-10-17 03:15:02 302 6214550 2021-10-17 03:15:02 2021-10-17 03:17:03 4,021 6214551 which i need to split out in to buckets constrained to either the end of the…
As part of a larger Postgres query, I generate all years between two given timestamps (timestamptz): select to_char(generate_series, 'YYYY') from generate_series( '2022-06-14 11:00:00.000+00'::timestamptz, '2023-06-14 11:00:00.000+00'::timestamptz, '1 year' ); Which returns: '2022' '2023' The issue is, if there is less than…
I am currently working on a function in Postgres. I have the function working, but I need to add a loop inside the json_build_array() function to add multiple of what is inside the array. This is what I currently have:…
I've have a Postgres database and I'm using Grafana to visualise some data. For instance, my Grafana panel has the following variables where the values are dynamic: $__timeFrom() = '2023-10-21T00:00:00Z' $__timeTo() = '2023-10-21T00:25:00Z' $__interval = '15m' These variables are used…
I thought I understood GENERATE_SERIES(), but obviously not as well as I thought. I have a table: CREATE TABLE status ( start_tz TIMESTAMPTZ NOT NULL, end_tz TIMESTAMPTZ NOT NULL, ms TEXT NOT NULL, sensor_id SMALLINT NOT NULL, ); And I…