i have a table that looks like this: id position value 5 senior 10000 6 senior 20000 8 senior 30000 9 junior 5000 4 junior 7000 3 junior 10000 It is sorted by position and value (asc) already. I want…
I have two tables in my Postgres DB (v14), tags and locations. Example of tags: id | tag_name ----+------------ 1 | football 2 | tennis 3 | athletics 4 | concert Example of locations (where tag_ids is array of ints):…
I am using Supabase as my DB. I have users table with id field being populated with uuid_generate_v4(). I also have table bank_ao with foreign key bankId pointed to users.id. When I do following: const uuid = req.params.id //this 100%…
I have a table and I want to add some rows based on column 'days'. And for each of those rows, the 'Date' column will increment by 1 day. For example: Table X: Date Group days 1/1/2023 A 3 5/1/2023…
i'm creating a trigger that triggers on INSERT on a table, and i wish to log the structure of tables inserted so i wrote this Function CREATE OR REPLACE FUNCTION update_table_log_received() RETURNS TRIGGER AS $$ DECLARE added_column TEXT; target_table_name TEXT;…
I have following class: public class Person { private String firstName; private String lastName; private List<String> habits; } I have Postgres query which returns me following result using inner join from 2 tables name | lastname| habits -------------------------------------- John |…
I am very new to Go world. I have some db functions that I need to test. So first I have a database.go file that connects to a postgres db: import ( "fmt" "gorm.io/driver/postgres" "gorm.io/gorm" "os" ) var DB *gorm.DB…
So, I did some work on my Mac with PostgreSQL about 6-7 years ago. I am trying to get back into it and am following along with a tutorial. There are two issues that I have ran into regarding my…
I am trying to connect to a Postgres instance running in a Docker container. In the docker-compose file, the postgres service looks like this: flask-api-postgres: container_name: flask-api-postgres image: postgres:13.4-alpine env_file: - dev.env ports: - "5433:5433" networks: flask-network: With docker inspect…
My data looks like this: id user data date 1 1 1 2023-02-05 2 2 1 2023-02-05 3 1 2 2023-02-06 4 1 3 2023-02-07 5 2 5 2023-02-07 I want to get a difference between data of each row…