I'm trying to insert an entry into my database with a one-to-one relationship to another entity. I'm using spring data jpa and postgres. My code looks as follows: @MappedSuperclass @Getter @Setter @ToString public abstract class Post { @Id @GeneratedValue private…
So I am using rest api as back end , I am unable to edit so I found that the token needs to be passed , from login to this change-profile api , so that the user can succesfully edit…
This is the table goodsandcat Item Key Electronics 0 Smartphones 1 Laptops 1 Cameras 1 Headphones 1 Clothing 0 T-shirts 1 Jeans 1 Dresses 1 Jackets 1 Column Item has names of categories and goods with their respective 0 and…
I would like to create a function that given a value of any type, a dimension of the one-dimensional array and the column to set, will return a one-dimensional array filled with null values except for one given value at…
I have this Oracle query implemented as HQL and Spring Boot query which I want to migrate to PostgreSQL @Query("select profileId from HrDepartment where profileId = :id and profileId is not null and rownum = 1)") String getProfileId(@Param("id") String id);…
I have the table in POSTGRESQL. How can insert row if in the table is not exist or update if exist by appending array in last table (Adding to the array should add new text in last column, like "1.…
Perhaps, I'm overthinking this, but I can't seem to figure out how to take a list of decimals and group it into data ranges and get a count for each range. Ideally, I would want the minimum value to always…
When I try to copy a CSV file with pgAdmin or just COPY command it shows me this error ERROR: nieprawidłowa składnia wejścia dla typu integer: "1,"A Dijiang","M",24,180,80,"China","CHN","1992 Summer","1992","Summer","Barcelona","Basketball","Basketball Men's Basketball",NA" CONTEXT: COPY olympics_history, line 2, column ID: "1,"A Dijiang","M",24,180,80,"China","CHN","1992…
I have a table: CREATE TABLE T ( order_id Integer PRIMARY KEY, items_current_order Integer[], items_next_order Integer[] ); INSERT INTO T(order_id, items_current_order, items_next_order) VALUES (4254677, '{1, 1, 1}', '{1, 1}'); INSERT INTO T(order_id, items_current_order, items_next_order) VALUES (4254645, '{1,2,5,6}', '{1,1,6}'); I need…
My question is quite similar to this, but instead of the mean, I need to find the median value over different columns of a row (in order to identify some outliers). Suppose I have the following table: X Y Z…