This is my sample data id|score| --+-----+ 1| 10| 2| 20| 3| 30| 4| 40| 5| 50| 6| 60| 7| 30| 8| 30| 9| 90| 10| 100| My expected output is id|score|_prev_element| --+-----+-------------+ 1| 10| NULL| 2| 20| 10| 3|…
I have a table that records the login information of users on a website, including ID and login date. For example: id user_id date 1 1234 2024-01-01 2 2341 2024-01-07 3 2341 2024-01-13 4 3412 2024-01-20 5 4123 2024-01-20 6…
I tried to create a 1-to-1 relationship in PostgreSQL but when i check the ERD it looks like a 1-to-many relationship. this is my SQL script: CREATE TABLE capital ( id SERIAL PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE country…
Are there any more elegant ways to use Drizzle ORM in Nest.js besides the providers? For example like in Prisma with PrismaService, all I found is only with providers like: import { Module } from '@nestjs/common'; import { ConfigService }…
I have a Spring boot app with custom queries. I need to find all database rows according to condition - if :myFlag is true, field in database must be in a list (:values here), or null. Can I use something…
I have a JSONB column in a postgres database. The json object it holds is structured like this: { "kws": {}, "distinct": 0, "count": 0 } Some of the records have nonzero/non-null values, of course. A colleague has inserted quite…
I want to return all cities whose all postal codes are contained in an array of certain postal codes. On the backend I have an array containing postal codes. The array looks as follows: [41200, 41201, 41202, 42500, 42501, 42504,…
I have the following function that contains a CTE: CREATE OR REPLACE FUNCTION create_job( in_partition_id VARCHAR(40), in_job_id VARCHAR(48), in_name VARCHAR(255), in_description TEXT, in_data TEXT, in_job_hash INT, in_task_classifier VARCHAR(255), in_task_api_version INT, in_task_data BYTEA, in_task_pipe VARCHAR(255), in_target_pipe VARCHAR(255), in_prerequisite_job_ids VARCHAR(128)[], in_delay INT,…
I am trying to generate a query with an ordered ranking of duplicates. For example if I have the following table id | col1 | col2 | col3 ---+------+------+------ 1 | 3 | a | x 2 | 2 |…
I'm currently working on a Django project where I'm using a virtual environment (venv) to run Django locally on my machine (Windows). Additionally, I have a PostgreSQL database running in a Docker container. I'm encountering issues trying to establish a…