Postgresql – SQL set of filters
I am facing with a little challenge. I know that this kind of challenge should be solved by using python but I have decided to do it with SQL. And I am looking for little help as I am kind…
Postgresql – The number of groups and the total amount per request in EF Core
I have a some table in a PostgreSQL database: id internal_id external_id value --- ----------- ----------- ----- 1 1 null 5 2 1 null 3 3 null 2 8 4 null 2 3 5 3 null 2 6 null 4…
How to connect PostgreSQL database from flutter?
I want to connect PostgreSQL to my flutter application as my database for it. Is shelf package relevant or should I make API for the same. Please tell, I am finding solutions from many days but today I got to…
Postgresql – Using cast in case when expression
I want to write this type query : SELECT CASE WHEN t1.date_closed - t1.created_date < t3.estimated_solution_time_minutes THEN 'не в SL' ELSE 'в SL' END AS result but t1.date_closed and t1.created_date are intervals like this '2023-05-02 11:30', but t3.estimated_solution_time_minutes is integer…
Postgresql – Time out error when connecting to my postgres enterprise manager server
I installed postgres enterprise manager,EDB extended server as well as PEM agent from their official website.I navigated to the web interface using my ip address.Each time I try to connect to the server I keep getting timeout error despite inputting…
Postgresql – PEAN auth app: Why does the Angular interceptor always return null using BehaviorSubject?
I'm building an authentication app using the PEAN stack (i.e., PostgreSQL - ExpressJS - Angular - NodeJS). For authentication, I'm using express-session on the backend. I check for user sign-in status as follows: On the backend, check the session cookie…
Encountering error while trying to start postgresql server with a newly initialize database in a different location with pg_ctl command
When I run the following command to start the server with database in a different location: /bin/pg_ctl -D /path/to/db -l logfile start I face the following error : waiting for server to start..../bin/sh: 1: cannot create logfile: Permission denied stopped…
Postgresql giving syntax error for offset ? rows fetch first ? rows only
My spring batch application works fine with postgre version 'PostgreSQL 9.5.19'. I have to run this in a different environment with postgre version 'EnterpriseDB 9.5.0.5'. The following error comes. Is this a version problem? How to resolve this? Even though…
Postgresql – SQL query to identify continuous events that satisfy a condition group by product id
I have data that looks as follows. timestamp productid measure 2022-01-01 00:00:00 1 4 2022-01-01 00:01:00 1 5 2022-01-01 00:02:00 1 6 2022-01-01 00:01:00 2 5 2022-01-01 00:00:00 2 7 2022-01-01 00:01:00 3 9 The table records the telemetry of…
Postgresql – Typeorm/Postgres blog like constraint
im creating a blog where you can like a comment or a post with typeorm and postgres, here is the like entitie: @Entity() @Unique(["user", "post", "comment"]) export default class Like { @PrimaryGeneratedColumn() id: number; // @Column() // likeCount: number; @ManyToOne(()…