I have a table named "article" containing 1,145,141 records with various fields including "id," "uiqPID," "tenant," "status," "title," "body," "user_id," "category_id," "created_at," and "updated_at." The "status" column can have one of three values: 'PUBLISHED,' 'DRAFT,' or 'ARCHIVED,' with the following…
I am trying to update the records of one table using others but getting failed with the error. Can someone pls help how to fix the below query for updating records : ERROR: multiple updates to a row by the…
I have the following query to display the performance of a machine in 8-hour segments (although it can change to 1 hour, 1 week, 1 month, etc.). My table has 2 million records, and the query takes 10 seconds to…
I have a customer table having following colums - customerId-primary key, customer_name, food_preference, country, wallet_balance. The requirement is to get all customer data with - food_preference is vegetarian country is"USA" wallet_balance greater than 5000 So in the CustomerRepo in my…
I would like to modify a function in my schema. When it calculates the other_leave_count_per_staff, it's getting the data from leave_type_table. In the table, i have a column calculate_efte, true or false (1 and 0). But in my function, i…
I have two tables with same structure. One table contains old value and another table contains new value of all columns. I want to get out out as columns as 1 column and old and new value row wise with…
I have a table in which the possible value is null, 0, 1 and 3. I have to select only the null and the value equal to 1 in strict order. The query I have is to long. Can you…
SELECT * FROM table WHERE NOT (table IS NOT NULL); finds all the rows in table that have a null value in any column. The logic is clear (see answer), but want to understand this syntax. A statement in an…
In Postgres, given a collection of date ranges like: meter_id device_id start_at end_at meter1 device1 2020-01-02 10:30 2025-01-02 14:00 meter2 device1 2020-01-02 10:30 2020-01-02 11:30 meter3 device1 2020-01-02 10:30 2020-01-03 11:30 I want to bucket the ranges into: a range…
Hi I am working in postgres. I have below table contract_para contract_para Id 1 2 3 4 5 contract_lines Id | para_id 1 | 1 2 | 2 3 | 3 Output contract_para_id | contract_lines_id | contract_lines_para_id 1 | 1…