Using jOOQ and PostgreSQL, is there a way to know what operation was executed for a MERGE, INSERT or UPDATE? E.g. using the example from jOOQ's documentation: create.mergeInto(AUTHOR) .using(create.selectOne()) // Suppose the last name is unique (natural key) in my…
I have a table with the lat & lng for two points: CREATE TABLE location_pairs ( lat_1 float, lng_1 float, lat_2 float, lng_2 float ); I also have a function that takes two lat/lng coordinates pairs and returns a table…
I want to get the list of users who are new users vs returning user. Report is taken for every week. If user logs in for the first time in a week he is considered as new user,in a week…
I have created Postgres database with Vercel, and when trying to migrate with command npx prisma migrate dev i receive: Environment variables loaded from .env Prisma schema loaded from prismaschema.prisma Datasource "db": PostgreSQL database "verceldb", schema "public" at "ep-curly-resonance-50034155.eu-central-1.postgres.vercel-storage.com:5432" Error:…
I am trying to add a Price column to my ASP.NET Crud, and it works. The only issue I am having is that it is taking the wrong input. I am a beginner so I must be overlooking something, but…
I have the following data: collection: id label created_at 1 Collection of CVs #1 2023-01-01 2 Collection of business cards #1 2023-02-01 3 Collection of CVs #2 2023-03-01 model: id label type format 1 CVs cv 21x29.7 2 Business cards…
I'm developing a full-stack application (React, Node, Postgres). When receiving the form data from the frontend, I expect certain variable names sush as firstName and I map firstName to first_name on the backend server to insert it into the postgres…
I have a function in Elixir using Ecto that preloads associations for a given entity. The current implementation looks like this: @spec get(integer() | String.t(), list()) :: t() | nil def get(id, preloads \ []) do Shop |> Repo.get(id) |>…
I have a piece of JSON which is defined as follows: declare JSON2 text = '{"ChannelIDs":[11,12,17,14,13],"SerialNumber":"940860"}'; Now I am able to access this directly as follows: declare SerialNumber2 text; declare JSON2 text = '{"ChannelIDs":[11,12,17,14,13],"SerialNumber":"940860"}'; SELECT Json2::json->>'SerialNumber'::text into SerialNumber2; Now that…
I'm follow up with this repo and try to connect psql from my local machine to Postgresql on docker image after running docker compose up -d but I got this error I tried with adminer portal that come along with…