I'm working on a rights verification system. In order to verify that the user has access to the documents, I make a request to the database There are 2 cases when you can get access: The user is in the…
I would like to to shuffle some columns from a table in Postgres database. I have 2 millions rows. I need to update all not null values by another. I need to keep the same dataset. It's not possible to…
I'm trying to join two tables, but I keep getting weird results, so I decided to do a SELECT * FROM transactions as t LEFT JOIN customers as c on t.customer_id = c.id just to see all the columns. When…
I have this data in my postgresSQL db. id client_id num 1 1 3 2 2 1 3 3 2 I want to create multiple entries for each unique client corresponding to the number in the num column. For example…
I'm trying to perform a following calculation in a query: t0.value1::decimal * 10 ^ (-1 * t2.value2::decimal) * t0.value3::decimal as total_value However since (-1 * t2.value2::decimal) returns -18 all the results are rounding up to 0. I tried explicitly stating…
I have looked at the COALESCE documentation and it mentions the typical case of using COALESCE to make default/situational parameters, e.g. COALESCE(discount, 5) which evaluates to 5 if discount is not defined as something else. However, I have seen it…
Question Imagine having the following PostgreSQL table: CREATE TABLE setting ( user_id bigint PRIMARY KEY NOT NULL, language lang NOT NULL DEFAULT 'english', foo bool NOT NULL DEFAULT true, bar bool NOT NULL DEFAULT true ); From my research, I…
Usually with WHERE clause in SQL queries, in WHERE we check from the table if a condition is met, but with the following code: SELECT name FROM teacher as T1 WHERE ( SELECT COUNT (DISTINCT T2.salary) FROM teacher as T2…
I have a scenario, where a trigger function is activated before an update of some sort. And in order for the condition to be met one of the columns must be excluded from the "OLD" and "NEW" objects. CREATE FUNCTION…
In a scenario where we have a many-to-many relationship, what would be the ideal thing to implement an endpoint where you can get the data registered specifically for user X? For example, a class having multiple teachers and a teacher…