Questions tagged as 'postgresql'

Tagged questions
1
answer

Select rows in a PostgreSQL array

I'm using the PostgreSQL and Python database to query it, I have the following modeling: I'mtryingtomakeaquerythatreturnsallOrderItemsofaOrdertoaarray,forthisImadethefollowingcode:selectARRAY(SELECT'('||translate(string_to_array(x.*::"text",...
asked by 11.12.2014 / 20:57
1
answer

error converting an Oracle procedure to a PostgreSql function in the pl / pgsql language

I have adapted the code, but the following error appears:    ERROR: relation "fields" does not exist CONTEXT: compilation of PL / pgSQL function "p_grava_log" CREATE OR REPLACE FUNCTION F_GRAVA_LOG ( TIPO character varying, C_TABELA...
asked by 07.01.2015 / 17:26
1
answer

select field text separated by comma return lines

Does anyone know how it is possible in postgresql to get a value inside a field of type TEXT that has comma-separated records to use in WHERE ? Example of values in the field (35693,35694,35695,35696,35697,35698,35699,713)...
asked by 26.02.2015 / 15:58
3
answers

Return the last entry of different Postgresql objects

Assuming I have two tables: Car containing: plate, year, ect .. Event containing: car, lat, long, date, time, etc. How could I return only the last entry of each car in the event table?     
asked by 12.02.2015 / 11:58
1
answer

Using Postgres on Android with AsyncTask

I'm trying to connect my app in android directly with the bank that is on a server. I made the connection in an AsyncTask, follow the code. public class ConnectionTask extends AsyncTask<Object, Object, Connection> { private final Con...
asked by 27.09.2014 / 17:12
1
answer

Add items from table 1 and bring rows indexed by table 2 code

I am very new to SQL and I am creating an application that brings the number of hours contracted, well the part that I have doubts in the query is the index of the lines ... I need the rows to not repeat the code from table 1 and add the item...
asked by 13.10.2014 / 15:57
3
answers

Difference between ways to perform a backup (disk space, buffer, etc.)

Suppose I have a machine with 10GB of free disk space, and I have a backup script of a postgresql database, which when run, backs up locally and then copies to another remote server. The problem is this, when the backup reaches...
asked by 12.02.2014 / 11:18
0
answers

Integer conversion on Controller Laravel

I have the following data in the controller: $sheets = printerChange::select('folhas'); $sheetsNew = printerChange::select('folhasnew'); $sheetsCompare = (int)$sheetsNew; if(!is_null($sheetsCompare > 0)){ $calcSheets->folhasnew = $re...
asked by 05.12.2018 / 14:21
1
answer

Configuration error on JPA and PostgreSQL connection

I'm having trouble connecting JPA to PostgreSQL. I think the problem is in the application configuration. I'm using the Java 8 version, and my pom.xml file is: <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www....
asked by 25.11.2018 / 22:07
0
answers

Insert Modal data into the table via Ajax PHP and JavaScript

I'm trying to insert data from a table of my Modal into the "parent" table of my page, basically I have a modal, where I gave a select to bring the data that is not in the parent table and the user insert that data, what happens is that the requ...
asked by 08.11.2018 / 19:44