I have to create a complete view of BTree index list to analyze the performances of each and to flush out abnormal indexes (includes or equivalent) to drop them... Nevertheless I cannot find a way to have the list of…
I have a query of the form: SELECT col1, col2, ( SELECT my_value FROM my_second_table WHERE my_table.value = ... ) AS potentially_null_column FROM my_first_table When SELECT my_value FROM my_second_table WHERE my_table.value = ... returns no rows, then potentially_null_column is set…
I have a Spring data JPA repository which is backed by a postgresql database. As part of the query I want to use an interval in the query. I managed to achieve it by creating an SQLFunction that casts the…
I want to execute a single update query and have a result of two values, the first a boolean (true if there is a record matching the ID), and the second a rows affected count or some other value to…
I have a test CTE as follows: with test_cte (month, company, probability, expected, actual) as (values ('2024-03','CompA',100,4,13), ('2024-03','CompA',80,7,13), ('2024-03','CompA',50,7,13) ) select * from test_cte What I would like to do is add a final column called 'expected_revised' which would be…
I want to have a result of unique row of id, date_col1, with max (or last) of date_col2, and the value contained in the same row as max(date_col2). My table is like this sample: id date_col1 date_col2 value 1 2023-01-02…
I have a users table in my Postgres database with a role column that uses an enum. The user can either be a CAPTAIN or PLAYER. DROP TYPE IF EXISTS USER_ROLE CASCADE; CREATE TYPE USER_ROLE AS ENUM ('CAPTAIN', 'PLAYER'); CREATE…
I am trying to makemigrations in my project with Django using postgresql. But I have been having the following error: (agenda_api) C:UsersfelipOneDriveEscritorioManagmentCursosDjangoagendadjagenda>python manage.py makemigrations Traceback (most recent call last): File "C:UsersfelipOneDriveEscritorioManagmentCursosDjangoagenda_apilibsite-packagesdjangodbbackendspostgresqlbase.py", line 25, in <module> import psycopg2 as Database File…
In the following scenario, there are 3 tables in a PostgreSQL database (tables and values are simplified for clarity). I am trying to get the following values: sum of the amounts for records (101, 102, 103) in the parent table…
I installed timescaleDb using Docker following this tutorial for the setup: https://docs.timescale.com/self-hosted/latest/install/installation-docker/ . I used this image : timescale/timescaledb-ha:pg14-latest Then I connected to the instance with pgAdmin and followed this official tutorial: https://docs.timescale.com/getting-started/latest/tables-hypertables/. CREATE DATABASE "test-timescale"; CREATE TABLE IF NOT…