Is it possible to force a SELECT statement on a table to include columns from that table in a WHERE clause, in Postgres? For example, given a table T with columns c1 and c2 can I force a SELECT on…
Here I have query in which I am trying to avoid the negative symbol in the final output. But why do I get that negative symbol ? I have try to use the replace() but it doesn't work. can you…
(I had originally asked this question on the DBA StackExchange, but didn't get much activity in it). In my DB, I have tables for items and connections between them, creating a likely sparse graph, with islands: CREATE TABLE IF NOT…
I have a MySQL table containing users, files and file ages as shown below. Users Files File age A 1 42 A 2 17 A 3 4 B 4 85 B 5 73 B 6 11 C 7 6 C…
I'm using Postgress DB in AWS and creating some views with calculations. I have multiple rows with the same ID but different Units and Subunits. I would like to get a Sum based on Value_1 and Value_2 in the SUM…
i am using this query to get cost of the product select SUM(strg_op.opcost)/ SUM(strg_op.opvalue * 1000) * strg_catgs.Disrate as totalcost from strg_catgs INNER JOIN strg_op on strg_op.ElemID = strg_catgs.elemID and strg_catgs.elemID =( select strg_catgs.elemID where strg_catgs.catID = '13' ) and…
Assume I have two tables related with one to many: Person: - name - age - phone Attributes: - fk - field - value for example Person: id name age phone 1 John 18 null 2 Sue 22 1234567890 3…
I have a PostgreSQL table named entity_changes with the following structure: CREATE TABLE entity_changes ( entity_id INTEGER, raw_time BIGINT, resolved_datetime TIMESTAMP WITH TIME ZONE, old_phase VARCHAR(255), new_phase VARCHAR(255) ); This table tracks changes in the phases of entities over time.…
I am using PostgreSQL 15 and have the following two statements in PL/pgSQL: -- Statement 1 SELECT to_json(T) FROM (SELECT * FROM category WHERE category.id = 43) T) -- Statement 2 SELECT json_build_object('products', JSON_AGG(T)) FROM (SELECT * FROM product WHERE…
I have a PostgreSQL (version 12.15) database with a table like this: id created_at number chat_id ... 2023-08-10 21:44:19.272299 0 27936 ... 2023-08-09 10:32:28.850167 0 27936 ... 2023-08-08 17:32:11.207523 0 27936 ... 2023-08-07 17:16:52.068309 0 27936 ... 2023-08-06 17:15:47.014364 0…