Timezone aware datatypes - PostgreSQL & MySQL, potential inconsistencies with UTC?2

postgresqlmysqldbfiddle

VéraceVérace

group on words in a varchar attribute

postgresql

Anonymous 2230Anonymous 2230

6If the words in your case are always going to be separated by the same character (like a space, for instance), you could try using the [`split_part()`](https://www.postgresql.org/docs/current/functions-string.html#id-1.5.8.10.7.2.2.31.1.1.1) function instead of regular expressions.

Andriy M

Enmascare data whit values short.2

postgresql

Anonymous 2226Anonymous 2226

5`pgp_sym_encrypt()` is provided by the extension [pgcrypto](https://www.postgresql.org/docs/current/pgcrypto.html). If it works in your local database, then you have installed the extension there.

Truilus

Calculate Year over Year and Quarter over Quarter percent change2

postgresql

Anonymous 2139Anonymous 2139

8If the table is guaranteed to have exactly one row for every quarter, you could try using the `LAG` analytic function to fetch a previous `spend_dollars` value:

Andriy M

PostgreSQL: Why does my foreach loop not work?4

postgresql

MoshinokiMoshinoki

5`foreach` is a PL/pgSQL structure. You can not use it in a SQL statement.

Truilus

JSONB: text contains array value?

postgresql

Anonymous 1800Anonymous 1800

3The expression `attributes->>'owning_groups'`

Truilus

Postgresql 9.6 - Multiply the previous rows and answer in the next row3

postgresql-9.6

greatmangreatman

Primary key to composite key without knowing constraint name3

postgresql

Anonymous 1800Anonymous 1800

6If you want, you can rely on the automatic naming pattern Postgres uses. For primary keys, this is always table_name_pkey unless you specified a constraint name.

Truilus

Upgrading Postgres 12 to 13: pg_upgrade.exe fails17

postgresql

Marc.2377Marc.2377

6The answer had to do with the option "*Beta: Use Unicode UTF-8 for worldwide language support*" being checked in my locale settings in Windows.

Marc.2377

Trigger code execution when exiting interactive psql client session

postgresql

PeterVandivierPeterVandivier