I have a SQL database for maintaining D&D games which has tables for things like Characters, Items, and Locations. I want to start modelling the relationships between all these different entity types, such as the relationship a Character has with…
How does ON predicate of Postgres LATERAL JOIN work? Let me clarify question a bit. I've read the official documentation and a bunch of articles about this kind of JOIN. As far as I understood it is a foreach loop…
So, I am trying to create a query that counts the numbers of Redirects per week per Site. I made the below query which gives me almost the correct results, but if there are no Redirects, there are no count…
I'm using macOS, building a Django app with Postgres and I want to containerise it with Docker. I have following files: Dockerfile: FROM python:3.11 WORKDIR /medicin_api COPY requirements.txt . RUN pip install -r requirements.txt COPY . . CMD ["python3", "./manage.py",…
I have a column in postgresql that is a text data type. But it really holds always 4 kind of values, these are: EOS,EOS in 6 months,EOS in 12 months, EOS in 24 months I always perform the same kind…
Here is a question concerning a basic DB query in PostGres. I have two tables created as follow: => create table Prix (rank integer primary key, value bigint unique); CREATE TABLE => create table Pris (rank integer primary key, value…
I have downloaded Lexer and Parser .g4 files from github grammars-v4 In Visual Studio I started a new Class Library project with the packages Antlr4 4.6.6 and Antlr4.Runtime.Standard 4.13.1 When I build the class library I see the following Errors…
I am trying to parse this sql query using spring data jpa to use in my application. It is a postgresql qurey using some of the geospatial functions using postgis. This query is basically trying to find all the records…
I have an entity that has, among other things, two jsonb columns : "options" and "features". I want to copy data from a field inside the options column to a two levels deep field inside features. What I've tried :…
I have a table test_table: Column | Type | ------------+------------------------+ id | integer | attributes | json | With content: id | attributes ----+---------------------------- 1 | {"a": 1, "b": ["b1","b2"]} 2 | {"a": 2, "b": ["b3"]} 3 | {"a": 3}…