I use Springboot3 and Jooq to create my project and define a custom delete method deleteByUsername follow jooq delete guide @Repository public class UserRepository extends UserDao { @Autowired public UserRepository(Configuration configuration) { super(configuration); } /* --- some query method can…
I wrote the SQL Server stored procedure usp_getrowcounts, shown below, that dynamically gets a row count from each table, as tables come and go, and need the equivalent dynamically generated and executed PL/SQL to work in PostgreSQL. However, working with…
I want to be able to call set_config to set a configuration parameter within the same transaction/scope as an INSERT statement. There is a function triggered AFTER the insert which reads from this configuration parameter. I need to accomplish this…
I am using postgres. What I have right now is like this: SELECT <statement> FROM ( <MASSIVE JOIN STATEMENT> ) UNION ALL SELECT <different statement> FROM ( <SAME MASSIVE JOIN STATEMENT> ) What I would really like is to have…
I am attempting to install a Keycloak Helm chart and would like to utilize an external data store such as LDAP instead of the default Postgres database. Is it possible to achieve this configuration, and if so, what steps should…
I have a text like this: 'a:b:c:d' I would like to ignore the last part of the split text, my result should be 'a:b:c' I tried split_part on it, but it doesn't work, neither applying reverse at it. Queries I…
I have the following tables (simplified) in Postgres: CREATE TABLE party( id int PRIMARY KEY, family_name varchar(50) NOT NULL ); CREATE TABLE election( id int, country_name varchar(50) NOT NULL, e_type election_type NOT NULL, e_date date NOT NULL, vote_share numeric, seats…
I've worked out how to split a string into an array, but I'm not sure how I can use a trim function on each element to remove any whitespace. Right now, when I select and separate the field, I use…
I have an entity Store that stores in itself @Entity('shops') export class ShopEntity{ @PrimaryGeneratedColumn() id: number; @OneToOne(() => ScheduleEntity) @JoinColumn() schedule: ScheduleEntity; } I also have a Schedule entity @Entity('schedules') export class ScheduleEntity { @PrimaryGeneratedColumn() id: number; @Column('jsonb') monday: DayDto;…
I have a table in Postgres 14.9: Name (Txt) Detail (JSONB) state (JSONB) apple [{ "code": "156", "color": "red" }, { "code": "156", "color": "blue" }] [{ "ap": "good", "op2": "bad" }] orange [{ "code": "156", "color": "red" }, {…