In postgres, what data type should I use to store a unique set of strings? Is using a simple array then when I want to write, I read the current set of strings, determine what the final set should be…
If I have method with @Transaction(with default isolation level) and after all it send commit to DB, DB set transaction's visible for other and send response back to me, but network is lagging and I receive timeout. What happens? Transaction…
I want a query that retrieves the result of values if it doesn't exist. Example: select * from the table.A where column1 in (1,2,3) If 2, 3 values exist then I will get 2 and 3 as a result. But…
Is postgresql can do average for rolling data? I have this case where I need to average the values for 5 days and get all the days filled up while waiting for the actual values so basically if I'm in…
There's a table: create table mytab( r char(38) not null, h char(2), p bytea not null, primary key (r,h) ) I'm inserting hundreds of rows at once, like this: insert into mytab (r, h, p) values ('val_r', 'a0', 'pr_1'), ('r1',…
I am having a table where one column is a JSONB column that has the following payload: [ {a: "foo", b: "bar"}, {a: "bar", b: "baz"} ] I want to remove the "b" element for each array item: SELECT json_build_object(…
I have two tables time_info and category. I want to update the temp_id of time_info table whenever there is insertion of record or update of duration column of time_info table. Here is the schema time_info id name - text duration…
I have downloaded postgreSQL version 15 and when I started the download the drivers, half of the drivers were not installed properly and then when I opened pgAdmin, it is stuck and not running further. What should I do? Please…
I have a table of real estate data with lots of NULLS in address column. I want to replace these nulls based on the unique ID. (I'm following Alex the Analyst tutorial). However when I use this in postgresql, I'm…
I've looked across a lot of Q&As for this, but haven't found any real answers, so I made this question. A lot of tech companies don't actually use foreign keys. Whether it be for easier migrations, or performance improvements, that's…