I have a following table I need to only select all the values with sensorfield1 flag = r and reject the rows with corresponding IDs with flag = h and select those values for IDs where flag value is only…
I got this error when I try to get the list of all rows on my table. This only happens because I include one of the column in the SELECT. The column itself is an enum column and I wanna…
I have arry of strings in a column like : ["196 2616", "9503744", "36.25260-6027", "2 414 425", "7 034 771 6", "F709714", "1088229", "183144", "505870338", "105075"] I want to search if this array contains for example 2 414 425. I…
I tried to write function like this in PostgreSQL but I'm getting error like ERROR: syntax error at or near "elems" LINE 22: RETURN elems; I want get output like input: we@@@ty;rer@@2hjjj output: we@@@ty rer@@2hjjj please help me to solve…
I am trying to create a FOR loop to loop through an array list of table names. Something like list=['tableA','tableB','tableC']; for x in list{ select * from x; } basically doing this select * from tableA; select * from tableB;…
I made two statements - SUM of revenue and expenses in different tables using group by id (each id has more than one revenue and expenses records): select id_person, SUM (revenue_d) as sum_revenue from sales group by id_person; select id_person,…
I have a table with position (junior, senior), salary, and an ID. I have done the following to find the highest salary for each position. SELECT position, MAX(salary) FROM candidates GROUP BY position; What I am getting: How I want…
What is the best practice to encode this relationship in a postgres database schema? Given the following entities: Document, Profile, Message And the following relationships: One Profile to many Documents One Message to many Documents Essentially documents are a shared…
To persist I use Hibernate 6 and use on the entity: @JdbcTypeCode(SqlTypes.JSON) private String value; When you save to the database, save wrapped in quotes and inside the json escape the quotes: "{"name":"pepito", "lastname":"perez"}" when I use the query to…
I would like to store an display OpeningHours for stores like this slots example: mon = 9h00 => 12h00, 14h30 => 20H00 tue = 9H00 => 20H00 we = 14h15 => 20h00 thu = closed I need to use it…