Questions tagged as 'postgresql'

Tagged questions
0
answers

Subtraction return in postgres

I have a table with a field called VALUE double precision, and a function that returns another data also double precision, what happens is that if I do select (VALUE - function ()) the result in which case both the VALUE and the result of the...
asked by 10.12.2015 / 20:06
1
answer

SQL query according to Column make a new one

I have a column that is numeric. There are positive and negative values in this column. I need to make a query that when it is positive, I query Tabela A , when it is negative I refer to Tabela B . I have no idea how to do this, can...
asked by 11.12.2015 / 14:40
1
answer

Query Performance - Postgresql

I have the following situation, I need to bring data from a vehicle table of the system in which I work and another with integrated data of a partner system, because integration is not very consistent data and the way to connect the tables can b...
asked by 29.10.2015 / 12:21
0
answers

Postgres JDBC Error in Eclipse

I'm trying to do a project to test the connection in the PostgreSQL database (I'm using version 9.2) in Eclipse (Mars Version). I'm using postgresql-9.2-1004.jdbc3 and adding it to Build Path. However, when trying to execute the class to test th...
asked by 08.10.2015 / 04:12
2
answers

Problem connecting port 80 Apache

I'm trying to use BitNami Stack MAPP 5.5.30-0 (For Apache Web Server, PostgreSQL) When I try to configure Apache Web Server I get this error: "Can not bind to port 80. It is probably taken by another application or you do not have enough priv...
asked by 05.10.2015 / 02:15
1
answer

Returning an array from a function in PostgreSQL

I have a question here that I need to troubleshoot with a function in the postgreSQL database. The problem is this, I need to cross a table called stock_alt with a view called stock . In this table inventory_alt are only the codes of the...
asked by 01.03.2016 / 15:07
1
answer

Select in database, only with jQuery [duplicate]

How do I make a select in the database using only using a jQuery? I have two combobox and I want to use their value to make a select in my database: $.getJSON('/MinhaDoenca/rest/hospital/get', function(data) { for ( var...
asked by 08.11.2015 / 16:38
0
answers

Restful server error in tomcat

Could anyone help a problem with the REST server? I'm developing an android app and I'm working with a restful server, Postgres and Tomcat . And I'm having this error almost every time I make several requests: GRAVE: Servlet....
asked by 23.10.2015 / 15:47
0
answers

Wamp + Laravel 5.1 + Postgresql

Has anyone ever set up Laravel 5.1 to run in Wamp using postgresql database? I have a Laravel installation running on a WAMP server, but when I run the "php artisan migrate" command I get the following error: "[PDOException] could not find dr...
asked by 09.09.2015 / 06:22
0
answers

How do I make an incremental backup script in a postgresql database?

I would like to know how to do a .sp1 script to do a daily incremental backup? Gratitude!     
asked by 10.09.2015 / 20:21