I'm trying to write a query that will show me the difference between the current value and the previous one from the query result. It seems to me that this can be done with the "OFFSET" or "LEAD" method. But…
I want to select from table C all items ID where column A "item_a_id" and column B "item_b_id" not in result of another query. currently I use this query twice , i didnt find a way how to query it…
I need to replace H2 with PostgreSQL at the WSO2 API Manager. Since there is currently data saved on H2, I need to pass it to PostgreSQL. I found the command SCRIPT TO 'dump.sql' to export the data to .sql…
ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:5432 at Client._connectionCallback (/home/gene/capital_greek_project/api/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:131:24) at Client._handleErrorWhileConnecting (/home/gene/capital_greek_project/api/node_modules/pg/lib/client.js:305:19) at Client._handleErrorEvent (/home/gene/capital_greek_project/api/node_modules/pg/lib/client.js:315:19) at Connection.emit (node:events:527:28) at Socket.reportStreamError (/home/gene/capital_greek_project/api/node_modules/pg/lib/connection.js:52:12) at Socket.emit (node:events:527:28) at emitErrorNT (node:internal/streams/destroy:157:8) at emitErrorCloseNT (node:internal/streams/destroy:122:3) at processTicksAndRejections (node:internal/process/task_queues:83:21) { parent: Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect…
How to select more than one value from a 'non-existing' table. For example: SELECT ('val1', 'val2') as "test" How to make a column "test" with two values/rows val1 and val2?
i have created procedure, inside used cursor to update the some data, while calling the procedure it's getting the error. create or REPLACE PROCEDURE bal_upd(p_id int) as $$ DECLARE rc record; ----- cursor bal_upd1 CURSOR (p_id int) for select *…
How to correctly resolve a Promise.all(...), I'm trying that after resolving the promise which generates a set of asynchronous requests (which are simple database queries in supabase-pg SQL) I'm iterating the result in a forEach , to make a new…
I'm facing issues with a jsonb ARRAY column in PostgreSQL. I need to sum this column for each row. Expected Result: index sum(snx_wavelenghts) 1 223123 2 223123
I come from MySQL to PostgreSQL then, I created test table with BOOLEAN state column in PostgreSQL as shown below: CREATE TABLE test ( state BOOLEAN -- Here ); But, I couldn't insert TRUE with 1 and FALSE with 0…
I had to select from the column all the values that contain numbers (NULL values aren't interested). How can I make a query to my table using something like this: SELECT c1 FROM t1 WHERE c1 ...; I tried to…