I have a table like this one | two | three | code | four -----+-------+-------+---------+-------- 0 | 21750 | 10110 | 1016916 | 20.0 0 | 21750 | 10111 | 1017949 | 20.2 0 | 21750 | 10115 |…
I have installed postgres-16-beta and I was assigned to a project to make possible to use AGE with PostgreSQL 16. I have configured postgres with: ./configure --prefix=$(pwd) --enable-cassert --enable-debug CFLAGS="-ggdb -Og -g3 -fno-omit-frame-pointer" After that the make install command is…
SELECT v.accounting_date, v.payment_date FROM (SELECT doc.document_id, max(CASE WHEN doc.name='accountingDate' THEN doc.value END) AS accounting_date, max(CASE WHEN doc.name='paymentDate' THEN doc.value END) AS payment_date FROM go_appr_doc_variables doc GROUP BY doc.document_id) v WHERE TO_CHAR(TO_DATE(v.payment_date, 'YYYYMMDD')+8,'yyyymmdd') >= TO_CHAR(NOW(),'yyyymmdd') v.accounting_date and payment_date values format is…
I have some NativeQuery in my code which looks like this and where "stateValue" will be calculated and can be 1 or 0: SELECT MAX(CASE WHEN(? < t.someDate + interval '3 months' ) THEN 1 ELSE 0 END) AS stateValue…
My first post in Stackoverflow. I am trying to learn Postgresql (12) "on the job" and seem to be stuck on a rather simple issue. I have a simple database with 12 rows. In one column (int) there is a…
I'm trying to come up with a good database design for this use case I have a table called expenses as follows id category_id item_id Problem item_id column wouldn't make sense if the expenses category is i.e. "Rent" It would…
I am currently migrating a PostgreSQL procedure to work in Redshift Spectrum Serverless. I was able to have a working procedure that works as intended in Redshift. However, its originally used inside a SQL select statement and I am currently…
i have a query in postgres which is taking 1 min and a few seconds to execute, found out that it's due to the order by clause. my understanding is that order by clause is one of the last to…
I want to combine the power of Apache Age, a graph database system, with PostgreSQL to leverage graph database functionality in my application. How can I achieve this integration? I expected to successfully integrate the two systems to leverage graph…
Using Node to connect to PostgreSQL database and make a POST request. The database itself is connected (tested with some simple GET requests). But it seems that for some reason the client is not defined when running my registration function.…