I want to join columns from several tables. For one table join works fine select org.catalog_truck.plate_number as "Госномер грузовика", shift_id as "ID смены", trip_id as "ID рейса", * from core.monitoring_stages join org.catalog_truck on vehicle_id = org.catalog_truck.catalog_truck_id where gen_id = (SELECT…
I am trying to write a query that tells me every distinct code in my table that has more than 1 distinct display associated with it. Example: code display 1 North 2 East 2 South 2 South 3 East 4…
I have a table with multiple columns.’Product Name’ being one. Table has records for multiple products. product name is also used in a free text field. I need reports on how many rows have a particular product listed in ‘Product…
I have a table invitations keeping for each user the email invitations he received. One user can have many emails, on each email can be received many invitations. create table invitation ( user_id INT NOT NULL, email VARCHAR(32) NOT NULL…
I have a PostgreSQL database with a JSONB column named properties. I'm trying to create a query that matches all elements with a value inside properties that matches a certain value. Currently, I'm using a combination of jsonb_path_exists and like_regex,…
I'm using postgresSQL and would like to find the minimum value and the maximum value in one column. I have to have a column titled Order ID, Minimum Order, Maximum Order in the query. See the below code for what…
My system is using PostgreSQL as the database. I am encountering an issue when using a query to join two large tables together. I'll briefly describe the tables as follows: Location: - id: uuid - name: string (indexes) - country:…
I'm working on a NestJS application with TypeORM and PostgreSQL, and I need to fetch a list of users sorted by the timestamp of the last message they sent. I have two entities, User and Message, defined as follows: user.entity.ts…
I have a json (not jsonb) column in a PostgreSQL (version 13.12) table from which I want to remove specific values of an array attribute. For example, in the following table (db-fiddle) I want to remove all occurrences of "D"…
I am suffering with a very strange and annoying problem... I am driving the situation crazy: I have created a docker container that has the following configurations: Dockerfile # Dockerfile FROM php:8.3-fpm # PHP INI COPY /docker/php/php.ini /usr/local/etc/php/php.ini # Install…