I have a test which many records over time. I am using Postgresql to store these tests and records and I want to be able to search for tests that have records that fall within a certain time range. A…
I need to insert data into new table person_department using recursion. My tables for now: person id group_id 800 10 805 21 department id name group_id parent_id 1 ABC 10 5 2 TY 11 5 5 OOO null 9 6…
Mac M1, Serverpod 2.0.1, Flutter 3.22.2 • channel stable • https://github.com/flutter/flutter.git Framework • revision 761747bfc5 (5 weeks ago) • 2024-06-05 22:15:13 +0200 Engine • revision edd8546116 Tools • Dart 3.4.3 • DevTools 2.34.3 I am trying to get the email…
What is the use of postgres regclass datatype in user tables? When would one want to use them when regular data types are available? If any tables have these data types, since pg_upgrade would fail, what data types should those…
I started to follow the official documentation of gcp in order to import my csv data to an instance on cloud spanner spanner, but I'm getting thhis error: *Error java.time.format.DateTimeParseException: Text '2024-05-30THH24:16:30.892' could not be parsed at index 10* I'm…
I have a table people(gid int, name varchar) with data: gid name 1 Bill 2 Will 2 Musk 2 Jack 1 Martin 1 Jorge now I want to get a result set like below: gid representative(varchar) 1 Bill, Martin 2…
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…
Suppose I have the following data, and I want to know for each person what was their highest performing period, breaking ties in favor of more recent periods. I would like to see ONLY the following rows: 5 (Alice's best…
I am building a function to insert a record into an audit table every time a record is inserted, updated, or deleted in the parent table. I am struggling to insert one JSON object that is the primary keys of…
django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: nodename nor servname provided, or not known My Django project was working great until I changed the setting.py file to deploy it in Railway, using the variables Railway provides. Since then,…