Why does EF Core add the "RideId1" property to my model "RidePrice"? The error message from EF doesn't provide much help: "The foreign key property 'RidePrice.RideId1' was created in shadow state because a conflicting property with the simple name 'RideId'…
I want to run a query towards PostgreSQL where any attribute in a JSON body matching a list of attribute names should equal a given value. The input: names: ["foo", "bar"], value: 'hello' should render a query such as SELECT…
I'm creating a function for Apache AGE, and I need to iterate over a List of graphids, how should I do it properly? The List I'm referring to is the PostgreSQL defined struct in this file -> Postgres' GitHub repository…
The table is like: country fruit size Japan Apple Big Japan Apple Small Japan Orange Big Singapore Banana Small The expect output is like: country type total Japan 2 3 Singapore 1 1 I managed to run the counts separately.…
The new release of spring-boot 3.1 added support for managing testcontainers when running your app in development: https://docs.spring.io/spring-boot/docs/3.1.0-SNAPSHOT/reference/html/features.html#features.testing.testcontainers.at-development-time. I'm attempting to get it to work with the specific postgres version I'm using for my project, but I'm running into issues.…
I'm learning PostgreSQL and I'm trying to understand the details of how to choose how to scan this database. I have postgtresql 14.2 and run the following code: DROP TABLE IF EXISTS t_test; CREATE TABLE t_test (id serial, name text);…
I have the following sample data with 3 columns, i.e., account_id, interval_start, interval_end. And I want to create a reactivated column with the given output in the following table. For each account_id, reactivated column should start with a 0 value…
I'm storing a list for each user. username|index|... john | 1 |a john | 2 |b john | 3 |c jane | 1 |... jane | 2 |... Suppose I were to do an addition for john before his index…
I am writing a PostgreSQL trigger function that will allow me to do an ETL transformation on a data. I have a table with fields (id, price, EFF_FROM, EFF_TO), and if I only insert (id, price, EFF_FROM), EFF_TO needs to…
Basically, I am trying to create a tag search system for images, in which each image has an array of tags within a jsonb field image_data, like so: id image_data 1 {tags: ['landscape', 'dog']} 2 {tags: ['landscape', 'cat']} 3 {tags:…