I have two users: alice and bob. I have one organization: contoso. Alice is member of contoso. What I want is for alice to be able to add bob as member of contoso since alice is member of contoso. I…
i have a table called stock_holdings which does not have data related to account_id and ticker_cd (actually it is empty): select qty,total_amount from stock_holdings where account_id=1 and ticker_cd='XYZ'; qty | total_amount -----+-------------- (0 rows) however when i run the following…
I have two tables like this: collection_id added_on edited_on 1 2024-06-19 20:16:41 null 2 2024-06-19 20:17:42 null 3 2024-06-19 20:17:57 null and detail_id collection detail_type detail_value 1 1 title Book title 1 2 1 author John Doe 3 1 publisher…
Node.js / Nest.js /Typeorm /postgresql my code is i have table farm | id | center_point type GeoJson | point type GeoPoints| It can save to database, Does it have another way to update before commitTransaction ** if Transaction fail…
I have a jsonb field in a database table that holds the following data: {"access": { "D2024.06.13": [{"qty": 1, "time": "12:05"}, {"qty": 3, "time": "12:32"}], "D2024.06.14": [{"qty": 1, "time": "08:37"}] }} I would like to group the data by date…
I have a model with a jsonb field where responses from a third-party service are stored. The response changes periodically; some fields are added, some disappear. I want to generate a CSV from a sample of records. To do this,…
So i have this ENUM in my PostgreSQL: CREATE TYPE process_status AS ENUM('CREATED','ONGOING','DONE'); ALTER TABLE process ADD status process_status NOT NULL DEFAULT 'CREATED'; In my code: @Getter public enum Status { CREATED("Created"), ONGOING("Ongoing"), DONE("Done"); private final String status; Status(String status)…
I have a table like below. For a given id & a_id there could be different combinations of b_type, e_id, sp_id. br_type can be either B or H. b_type values EA means Excluded Party A, EB means Excluded Party B,…
I get this error: ERROR: 42601: syntax error at or near "ON" LINE 23: ce.image from cars_images ce ON (c.id = ce.car_id)) as images here is my code: SELECT c.id, c.model, c.description, c.environment, c.equipment, c.ps, c.tuv, c.cover, c.brand, c.price, c.engine,…
I have a database table cars that has close to 500k records. I was facing issues with long loading times to load data from this table. @cars = Car.order('created_at DESC').paginate(page: params[:page], per_page: 100) It took anywhere between 30-40 seconds to…