Questions tagged as 'postgresql'

Tagged questions
1
answer

PostgreSQL: Catching bugs and hits

I need a query to get the number of errors and hits from this table.     
asked by 15.05.2018 / 21:41
1
answer

What is the lowest direct query weight or using views for a double relationship?

Given the following hypothetical schema: create table cidade( cidade_id integer primary key not null, nome varchar(40) ); create table envios( id integer primary key not null, cidade_origem_id integer, cidade_destino_id intege...
asked by 07.07.2018 / 16:38
2
answers

In terms of performance, "character varying" or "text" in PostgreSQL?

Before posting this question I searched the internet to know the differences and performance of each type and I came to the conclusion that I should discuss a little more about this subject here with the experts, rs, I already know the differenc...
asked by 28.11.2017 / 12:26
1
answer

Select the most recent record of a given table - PostgreSQL

I need to select the most recent record of my Estoque if the data column is different, I was able to bring the oldest one when the dates are different: SELECT codigosuprimento, numeroserie, max(data) FROM public.estoque where usa...
asked by 31.10.2017 / 12:33
1
answer

Problem in OnClick, I can not pass the Array information to a text view

I'm having problems to inflate a list with information from the bank, I want to get the information from the user and be in a list, but only with a data type as a name, but it presents the following error: Error message: FATAL EXCEPTION: ma...
asked by 13.09.2016 / 02:43
1
answer

Application to make emergency calls [closed]

I am trying to make my application make an emergency call when clicking the button, but when running it it presents the following error: ERROR: FATAL EXCEPTION: main Process: com.example.matheus.privatewalletm, PID: 28931 java.lang.IllegalS...
asked by 13.09.2016 / 20:03
2
answers

Ulitization IS DISTINCT FROM - Postgres

What is the best use of this function in Postgres IS DISTINCT FROM , doing tests got the same result using COALESCE but in less time, follow the test: SELECT COUNT(P.id) FROM produto P INNER JOIN cliente CL ON P.id_cliente =...
asked by 20.11.2015 / 14:11
2
answers

Restuful server instance on tomcat

Staff developed an app - link I'm using a restfull server connection with the postgree database in hibernate. This server is hosted in bitname on a tomcat, but sometimes for some reason it drops and it is necessary to restart the server...
asked by 05.11.2015 / 19:32
2
answers

MySQL Licensing

I'm starting to develop a system that runs on Android, Web, and Windows. The 3 versions should talk to each other and the three versions will have the same functions will be a port of the same application for 3 platforms. The system will be d...
asked by 26.12.2014 / 00:04
2
answers

Ignore point in a Query

I'm trying to run the following Query: select codigo from cliente where codigo ilike '%99.999.999%'; I found that by putting ilike , it would ignore everything, points and accents but I was wrong. In my system, I have a query scree...
asked by 31.07.2015 / 15:08