Posts by Jones713 • 25 points

• 0

  votes

  0

  answers

  32

  views

  Q: SQL doubt string_agg (Delphi+Postgres)

  Good evening. This sql was running exactly as I wanted, but yesterday started to get out of the field order g gallery.. It had an output (example) like this: GALLERY 10: 26 / GALLERY 11: 23 /…

  postgresql delphi

  asked 3 years, 6 months ago Jones713 25

• 1

  votes

  2

  answers

  65

  views

  Q: Statement update SQL

  Good morning. I have the following SQL running: UPDATE pessoas SET implante = true FROM saida WHERE saida.prontuario = pessoas.prontuario and saida.mes LIKE (date_part('MONTH', CURRENT_DATE) || '%')…

  sql postgresql delphi

  asked 3 years, 9 months ago Jones713 25

• 1

  votes

  2

  answers

  74

  views

  Q: Dúvida Postgresql

  Good morning. I have the following SQL working: Select g.galeria,g.tipo,g.finalidade,count(p.galeria) as total from pessoas p full join galerias g on p.galeria = g.galeria group by…

  sql postgresql delphi

  asked 3 years, 9 months ago Jones713 25

• 0

  votes

  1

  answer

  150

  views

  Q: Postgresql: Select between dates + time

  Good morning. In the movement table, I have, among others, the date and time fields. I need to select between the chosen date and the following day (Ex.: between 09/11/2020 and 09/12/2020). I need…

  postgresql delphi-7

  asked 4 years, 2 months ago Jones713 25