Questions tagged as 'postgresql'

1
answer

Error trying to update ClientDataSet Fields in Delphi 7

I'm migrating an application from Delphi 7 which was previously in FireBird and now I'm connecting to the PostgreSQL database, but there was a variable error with the help of the Stack staff, I discovered that it could be th...
asked by 27.10.2016 / 18:06
1
answer

PostgreSQL variable error

I'm migrating a FireBird application to PostgreSQL, I was able to connect the PostgreSQL database with the help of the Devart tool, but now whenever I try to make some access in the application there is a variable format error, p> Ilookedinmy...
asked by 24.10.2016 / 15:52
1
answer

Handle .txt file in Ruby and BD pupular?

I need to open a .txt file that has a sequence of strings separated by ";" and I need to put every ";" in a vector to later create a loop and insert into the bank. What I have: require 'pg' require 'active_record' = File.open('teste.txt'...
asked by 23.08.2016 / 18:17
1
answer

Add date with bank values. CakePHP 3.0

I need to make a calculation that adds an integer to a date. This whole number refers to days. $user = TableRegistry::get('PoliticaSenha'); $query = $user->find()->where(['id' => $usuario['politica_senha_id']])->first(); $dataTro...
asked by 25.01.2016 / 12:41
1
answer

Is there any tool that makes it possible to create an API based on my database?

I have a database all modeled and with a mass of data, now I need to develop an application that makes available through this REST API this database. I have two development fronts, the frontend and the backend. Is there any way to make this data...
asked by 13.09.2015 / 03:18
2
answers

Returning dates with zero count

I'm trying to use the coalesce function to return 0 when my query does not have a return value, but I have already tried a thousand and one shapes and can not return 0 at all. I want to know where I'm going wrong: select case wh...
asked by 28.04.2015 / 21:25
1
answer

Error creating a NOT NULL field in PGADMIN "contains null values"

I have a database already created, inside it I have a table already created. In it I need to create a field that is NOT NULL . I do everything via the graphical interface that is faster, I click on the > new column : table, giv...
asked by 01.04.2015 / 15:01
1
answer

Searching for data by MySQL in PostgreSQL

Is there any way to connect MySQL with PostgreSQL, so that MySQL DBMS is used but selecting data that is in PostgreSQL?     
asked by 02.04.2015 / 17:08
1
answer

Sql - postgres - Arbitrary precision :: numeric

How does arbitrary precision work by setting the column to numeric ?     
asked by 19.10.2015 / 22:04
1
answer

How to get the record total from a table

I need to know how many records there are inside my table and add the total found in a variable. I'm doing the following but it does not work: <?php $w_querybusca = "SELECT * FROM Elem_matr;"; $w_queryresultado=f_class_co...
asked by 26.11.2014 / 14:01