I need to insert a specific range of years and months into a table so I can relate some climate data to those dates. Just like the table bellow: year month 1961 1 1961 2 1961 3 1961 ... 1961…
Given the following query select * from jsonb_to_recordset('[{"a":1},{"a":2,"b":42}]') i(a int, b int) where i is not null I observe the result of a single row, which is the one where both columns are non-null. When negating the where clause to…
The value saved in the database is 0.0 as numeric data type, I need to retrieve 0.00 with the select. is there a way in postgres?
I have a Postgres db containing a table with a jsonb column tsent that contains the results of targeted sentiment analysis of text in another column. The data is structured like so: CREATE TABLE tbl(id int PRIMARY KEY, tsent jsonb);…
I have a table like below: city1 city2 dist New York Berlin 7900 Berlin New York 7900 Oregon Ohio 5700 Montreal Rio 5700 Ohio Oregon 5700 Rio Montreal 5700 Moscow Tokyo 4200 Tokyo Moscow 4200 Both row 1 and row…
I have two tables "Tasks"(300k rows) and "TaskAssignedRoles"(500k rows). CREATE TABLE public."Tasks" ( "ID" uuid NOT NULL, "RowID" uuid NOT NULL, "Planned" timestamptz NOT NULL, CONSTRAINT "pk_Tasks" PRIMARY KEY ("RowID") ); CREATE INDEX "idx_Tasks_ID" ON public."Tasks" USING btree ("ID"); CREATE…
I have docker-compose.dev.yaml file where I specified configuration for starting PostgreSQL and other containers. But the problem here is when I enter docker compose -f docker-compose.dev.yaml up --build command, I do not get my user created. To begin with, here…
Would be glad if you could help me out: Got a query that is supposed to take some task from the database (Postgres) partitioned table (partitioned by execute_ts) and take them to work thread-safely (with several workers in the service…
I have two tables in my database. companies table with basic information about the company | column_name | data_type | | ------------- | ------------------------ | | created_at | timestamp with time zone | | rating | real | | company_id…
I work with PostgreSQL. I have three entities: Product, Warehouse and ProductOnWarehouse. Product describes the product, its price and name, Warehouse describes the warehouse, its coordinates and name, and ProductOnWarehouse describes a specific product in a specific warehouse, including a…