Questions tagged as 'postgresql'

Tagged questions
1
answer

How to concatenate a value with a string

Hello, I need to create a function in postgresql that gets two ages and the function returns the dates of birth. I am having difficulty calculating the date of birth, I have already tried using interval and other date type commands to solve this...
asked by 07.10.2016 / 18:27
1
answer

Select with cast (numeric as decimal) works, but view creation does not

Good morning everyone! I currently work with postgresql and I'm doing a database migration, and I need to create a view of my old database tables. Well, I need the number columns to round with 15.3 but I'm finding a problem that I can not fig...
asked by 22.09.2016 / 15:24
0
answers

External and internal database

I am a beginner in programming Android and I have a question ... is it possible for the same application to have a database internal and external to msm time? For example, some information is stored internally where the user can have ac...
asked by 20.09.2016 / 03:05
0
answers

Losing connection to database. Postgress, Glassfish

After about 15 minutes my system stops communicating with the database. Log Entry Detail Close Timestamp 05/09/2016 21: 22: 30,287 Log Level ERROR Logger org.hibernate.engine.jdbc.spi.SqlExceptionHelper Name-Value Pairs {levelValue = 1000,...
asked by 05.09.2016 / 23:35
0
answers

Error inserting multiple lines PHP + PDO + POSTGRESQL

I am using the multiple insert, but the internal characters of the text have made the insert fail. I used the addslaches method in the string but the error remains, any suggestions of what I can do to get around? I have the following code...
asked by 22.08.2016 / 16:57
0
answers

Identify user by login

Hello everyone. I am developing a system that works with user registration and I have the following problem: in the system there will be 3 types of users: Administrator, Normal and Temporary. Depending on the type of user, the areas that he w...
asked by 18.08.2016 / 06:15
0
answers

Array with PHP and PostgreSQL

Hello, I have a problem with returning information from the database. It is returning me an unordered array and with information from another bank user. Here is the Index: <?php SESSION_START(); ?> <!DOCTYPE html> <html l...
asked by 18.08.2016 / 19:16
1
answer

Automatic creation of SCHEMA in postgresql

I'm having a problem with the following, I need to create a trigger that when a given row is inserted it creates a SCHEMA with a specific structure! For example, in the public schema, I have the client table, and when I insert some client, I nee...
asked by 18.07.2016 / 14:23
0
answers

query to get percentage

I am doing a query to get percentage by zone but it is not working me very well select nuts3_res_1amc.id as id ,nuts3_res_1amc.localidade as source, nuts3_trab.localidade as target ,nuts3_trab.id as id2, ((COUNT(*) * 100)/ (select count...
asked by 30.06.2016 / 13:14
1
answer

PostgreSQL Reserved Word Problems

I'm using locally a code downloaded from GitHub for educational purposes and I'm having problems doing the deploy of war, the error has to do with a reserved word from the bank used in the roles table Caused by: org.postgresql.util.PSQLException...
asked by 27.06.2016 / 15:21