I have PostgreSQL 9.6.23 on windows server 2019 i want to install PgAgent for scheduling backup and deletion of data PostgreSQL Stack Builder's doesn't have PgAgent like newer version How can i manually install it or if there is any…
I have a list of n rows (n < 100) with '#' separated values in postgres (version 13+) row value 1 'ABC#DEF#123' 2 'ABC#DEF#156' 3 'ABC#DEF#178' ... These values can be of any length (e.g. 'ABC#DEFDEF#GHIG#123123#456#678') There are no NULL…
I have a trouble with writing custom boolean template for where clause using QueryDSL. Simply I need to use arraycontains function to know that table.languages contains values at array of strings from filter. Why Hibernate can't execute this? The raw…
I have a table which looks like below: CREATE TABLE time_records ( id uuid NOT NULL, employee_id uuid NOT NULL, starttime timestampt NOT NULL, endtime timestampt NOT NULL ) There will be overlap in times between the records for the…
I need to count quantity of some condition and avoid 'NaN' in result. I tried ways with CASE and COALESCE constructions but have no needed result: -- 1st: it works with 'NaN' in part of results: SELECT response_date, COUNT(*) AS…
I am having issue with ALIAS variable "distance" in my PSQL query. (*please ignore that I am using voutecount as distance) SELECT rentalid, createdDate, votecount AS distance FROM rental WHERE longitude=? AND latitude=? HAVING distance < 25 ORDER BY distance…
I have the following SQL code: SELECT dip || ' ' || ( SELECT lib1 || ' ' || lib2 FROM bds WHERE dip_s = dip ) AS label, COUNT(dip) AS freq FROM current_table WHERE v_deg = '3' GROUP BY…
i would like to join two tables that have a common column for example "custcode". The table "customer" is filled with some customer data and the table "customer_address" with the customer addresses.Basically I would like to join the data of…
Would it be possibile to calculate the daily sum of hours based on the difference between time present in same colums? date time 2017-11-08 08:25:57 2017-11-08 12:31:59 2017-11-08 13:28:42 2017-11-08 17:34:13 2017-11-09 08:28:08 2017-11-09 12:31:15 2017-11-09 13:20:13 I can get…
SO i have a spring boot application, and configured postgresql, as below spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect spring.datasource.url=jdbc:postgresql:dburl spring.datasource.username=admin spring.datasource.password=XXX But I get failure on application start up that a datasource is not created No qualifying bean of type 'javax.sql.DataSource' available I decided to…