Tag: postgresql-9.5

Error with passing in the same variable into multiple parts of SQL statement

javascript node.js postgresql postgresql-9.5 sql

So I have a Node.js query that should pass in these three values and update a specific column by a specific amount for a user with a specific id: The ‘sqlStatement’ looks like: As you can see, it should pass in the values such that the SQL statement looks like: I’ve also tried to write sqlStatement as the below (and

PostgreSQL UPSERT (INSERT … ON CONFLICT UPDATE) fails

postgresql postgresql-9.5 sql upsert

I have a row in my postgresql database that I want to update. My code generates this SQL statement to insert else update the one field that’s changed: What I don’t understand is that I can select that one row and it is present with a non-NULL num_syncs. But the UPSERT is failing because it doesn’t (re)set num_syncs (value 4

Case statement in multiple conditions?

case postgresql postgresql-9.5 sql

I want to check the column mr.name, if mr.name is null then i have to replace mr.name as mr.ticket_no. How? Can use if else or case? When i use like this it will throw an error if mr.name = null means i have to replace mr.name = mr.ticket_no. I want to check the column mr.name, if mr.name is null then

Postgres & Rust R2D2: How to get array_to_json as text/string without the escaped double quotes?

postgresql postgresql-9.5 rust rust-cargo sql

I have the following SQL: This gives me following in PSQL: When I put a ::text: I still get the same: However on my rust app’s side using r2d2_postgres, I get an escaped string instead: Rust code: Outputs: How I can I prevent the escaping of double quotes? Answer The quotes are only escaped during printing. They are not escaped

Upsert query is not updating the the records in postgres

postgresql postgresql-9.5 sql

I am trying to Upsert into the target table from temp table but My upsert query is not updating the records in postgresql. Although it is inserting but not updating. Please find below query: Insert …

How to properly store a file location to a postgresql table?

postgresql postgresql-9.5 python python-3.x sql

I am very new to postgresql. I don’t plan to study it fully in-depth right now as I have other priority topics to finish. But now I need to know some basics of postgresql for the perfect completion of …

Variable value conversion from any case to smaller case in psql CLI

postgresql postgresql-9.5 psql sql

I was creating a script to create DB user in Postgres via psql CLI, the challanges I am facing is that value conversion from Any case to lower case is happeing or not able to find the solution for the same. As per my expectation the lowerVal variable should convert the inputValue into lower case value. Did the googles but