github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/migration/v2_to_v3/date_paiements.sql (about)

     1  BEGIN;
     2  ALTER TABLE paiements RENAME COLUMN date_encaissement TO details;
     3  ALTER TABLE paiements
     4      ALTER COLUMN details TYPE varchar
     5      USING CASE WHEN details > '0001-01-01' THEN
     6          'encaissement: ' || to_char(details, 'DD/MM/YYYY')
     7      ELSE
     8          ''
     9      END;
    10  COMMIT;
    11