| CREATE OR REPLACE FUNCTION f_add_business_day(start_date date, num_days integer) | |
| RETURNS date AS | |
| $BODY$ | |
| SELECT COALESCE( | |
| ( | |
| SELECT workdays.date | |
| FROM ( | |
| SELECT calendar.date::date, | |
| row_number() OVER (ORDER BY CASE WHEN num_days = abs(num_days) THEN calendar.date END, calendar.date DESC) as elapsed_days | |
| FROM generate_series( |
| WITH table_columns AS ( | |
| SELECT | |
| c.relowner as tableowner | |
| ,n.nspname AS schema_name | |
| ,c.relname AS table_name | |
| ,a.attnum AS ordinal | |
| ,QUOTE_IDENT(a.attname) AS column_name | |
| ,CASE WHEN STRPOS(UPPER(format_type(a.atttypid, a.atttypmod)), 'CHARACTER VARYING') > 0 | |
| THEN REPLACE(UPPER(format_type(a.atttypid, a.atttypmod)), 'CHARACTER VARYING', 'VARCHAR') | |
| WHEN STRPOS(UPPER(format_type(a.atttypid, a.atttypmod)), 'CHARACTER') > 0 |
| {# | |
| Compresses the columns of a table to the specified encodings. Unlike the compress_table macro in dbt-redshift, | |
| you have to manually specify the encoding of the columns you want to compress, it does not run and use | |
| the result of `ANALYZE compression <table>` which would is extremely slow to run every time | |
| on a large table, especially when there is nothing to do and the table is already compressed. | |
| If the specified column does not exist or if the specified encoding is identical to the current encoding, | |
| the column is skipped. | |
| ALTER statements are generated for each column where encoding needs to be changed. |
This document summarizes notes taken to make VMWare Fusion 13 Player work on Apple M1 Pro. It builds upon a previous (deprecated) document based on VMWare Tech Preview 21H1
VMWare Fusion 13 was released on November 17, 2022 and Fusion 13.5 on October 19, 2023
Created on: November 20, 2022
Updated on: June 1, 2024
| [11/19/2022, 11:19:07.391 PM] INFO global: Vagrant version: 2.3.2 | |
| [11/19/2022, 11:19:07.391 PM] INFO global: Ruby version: 2.7.6 | |
| [11/19/2022, 11:19:07.391 PM] INFO global: RubyGems version: 3.1.6 | |
| [11/19/2022, 11:19:07.391 PM] INFO global: VAGRANT_LOG="debug" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_EXECUTABLE="/opt/vagrant/embedded/gems/2.3.2/gems/vagrant-2.3.2/bin/vagrant" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_ENV="1" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_EMBEDDED_DIR="/opt/vagrant/embedded" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_VERSION="2" | |
| [11/19/2022, 11:19:07.393 PM] WARN global: resolv replacement has not been enabled! |
VMWare Fusion 13 is now released. Read Vagrant and VMWare Fusion 13 Player on Apple M1 Pro for the latest.
This document summarizes notes taken while to make the VMWare Tech preview work on Apple M1 Pro, it originated
Spent a few hours dealing with errors on RDS when upgrading from a postgresql 10.6 to 11.1. In case someone else is dealing with the same problems, this might be helpful.
A few things to know about this database:
This probably turned out to be a Good Thing (tm). If you are using PostGIS extensively, I wish you good luck.
I hereby claim:
To claim this, I am signing this object:
| SELECT so._id AS order_id, | |
| oi.value ->> 'id'::text AS id, | |
| (oi.value -> 'sku_id'::text) ->> '$oid'::text AS sku_id, | |
| FROM orders so, | |
| LATERAL jsonb_array_elements(so._extra_props -> 'order_items'::text) oi(value); |
| Customer customer = new Customer(); | |
| .... save customer ... | |
| Card card = new Card(cardHref); | |
| if (card.customer == null) { | |
| card.associateToCustomer(customer); | |
| } | |
| Debit debit = card.debit(...); | |
| DebitResult result = from(debit); |