Questions tagged as 'postgresql'

Tagged questions
2
answers

How to round up age with PostgreSQL?

I used the age() function, below, to calculate the age, from a date stored in a table: select pessoa.*, age(data_nascimento) from pessoa; Returned the range: 27 years 9 months 9 days Is it possible to round this range to only 27...
asked by 17.06.2015 / 03:07
1
answer

Add values from within a column with postgres

I'm trying to sum the values from within a column with postgres, the structure of the table is as follows: id |nome_municipio |valores 1 |Porto Alegre |100.01;95.0;50.1 2 |Ivoti |87.0;80.1;45.1 3 |Novo Hambur...
asked by 29.01.2015 / 03:11
3
answers

Find information from the bank table with PHP every 10 minutes [closed]

I need to fetch information from a database table every 10 minutes using PHP language. Does anyone have any idea how I can do this?     
asked by 21.03.2015 / 16:56
1
answer

Group cells case when empty sql

I am making a query in the database to know in which branch the customer paid a portion and what the normal value and interest that was paid. The parcel value is transaction 3 in the bank and the interest amount is transaction 59. Follow t...
asked by 17.12.2018 / 19:45
1
answer

Return from sql in text to model in the entity framework

I have the parents class and the state class: [Table("tb_pais")] public class PaisModel { [Key] [Column("id")] public int Id { get; set; } [Column("nome")] [Required(ErrorMessage = "O campo nome...
asked by 22.08.2018 / 20:19
1
answer

SQL JOIN multiple tables

I have 4 tables that I need to extract the results, but I always get duplicate records, can anyone help? tabclientes: codcli nome 1 A 2 B 3 C tabrepre: codrepre nome 1 AA 2 AB 3 AC tabvendedor: codr...
asked by 10.07.2018 / 23:00
2
answers

SQL Query to select student and student name

I have this simple relational model, and I need a query that selects the student and the student's name.     
asked by 13.05.2018 / 00:34
2
answers

Incorrect PostgreSQL Daylight Saving Time

With the change of daylight saving time start date this year, postgreSQL database is having problems (as well as several other systems), informing timezone with dls (daylight saving) from 21/10. How do I get the SGDB to report...
asked by 23.10.2018 / 23:54
1
answer

How to convert this character to PostgreSQL?

I'm using DelphiXE and PostgreSQL, I happen to need to insert some characters in the database that are not supported in LATIN1. My base is UTF-8, but as the system has been transported since the Delphi6 version, and the old base I'm using LAT...
asked by 25.04.2018 / 20:46
1
answer

Select only the days of a Timestamp

I need to select only the days of a subtraction of dates, and if possible convert that number to Integer , is that possible? SELECT (select count(numeroserie) as porcentagemTotal from public.lotesretornosuprimento where laudo =...
asked by 21.02.2018 / 14:53