Questions tagged as 'postgresql'

Tagged questions
1
answer

Library relational model?

Is this model legal or redundant yet? [Edited]Thedatabasehasbeenmodified.CanInowhavebetterconsultations?Here'showitisnow:     
asked by 07.06.2018 / 11:55
3
answers

Sum of a column is not giving the expected value

I have a dummy table with two columns and some data in it, depending on the image. When I execute my following SQL statement, the result of the query is 22. The result should not only be 12? I could not understand why. Could anyone e...
asked by 24.05.2017 / 03:04
1
answer

How to create postgre trigger

In relation to the table above, 1) Create a trigger that for each record inserted in tb_movimentacao, the balance of the account is updated in tb_saldo. Remember that if the release is of type 'C' increases the balance, if it is of type...
asked by 05.07.2017 / 02:11
2
answers

How to select only the people with the first name [closed]

I would like to know how to select people who have only the first name, that is, they do not have a last name. Example: Nome ---------- Leonardo Roberto Ana Júlio Maria Ana Expected result:    Ana, Júlio     
asked by 06.12.2018 / 11:26
1
answer

PostgreSQL error: org.postgresql.util.PSQLException: ERROR: portal "C_70" does not exist

We use a Java Web application with Postgres database to generate the Sped files and in the middle of generating the TXT file we are getting the error below. This portal "C_70" is not necessarily repeated, and it is not always the same lin...
asked by 28.05.2018 / 23:27
1
answer

psqlodbc.h: 54:23: fatal error: iodbcinst.h: No such file or directory

Error installing postgresql ODBC on ubuntu 64 How do I proceed?     
asked by 23.10.2017 / 15:01
1
answer

Check if value exists before doing update [closed]

I need to do a query to update a column, but only update the column if the data to be updated does not currently exist in that column.     
asked by 19.08.2015 / 13:36
2
answers

What are the differences between a PL / SQL programmer and an Oracle DBA? [closed]

Can one explain the differences between the PL / SQL programmer and the Oracle DBA ? I know there are many differences, but I'm not sure how to specify them. I have some doubts too ... For example:    Can a DBA program Procedures...
asked by 04.09.2017 / 16:31