Posts by Douglas Carlos • 11 points

• 0

  votes

  3

  answers

  5576

  views

  A: Incorrect daylight saving time on Postgresql

  Note if you work with systems of more than one time zone, I recommend setting in UTC. Note that you can set the time zone in ːTimezone="America/Sao_paulo" in postgresql.conf Copy the updated…

  database postgresql server

  answered 6 years, 1 month ago Douglas Carlos 11

• 1

  votes

  1

  answer

  88

  views

  A: A Rigger that checks the deadline for all products in the table

  Create the Trigger: -- Function: public.produto_vencido() -- DROP FUNCTION public.produto_vencido(); CREATE OR REPLACE FUNCTION public.produto_vencido() RETURNS trigger AS $BODY$ BEGIN UPDATE…

  postgresql postgresql-administration

  answered 6 years, 1 month ago Douglas Carlos 11