db fiddle, Markdown export, Firebird

dbfiddlefirebird

AriochArioch

External verification of `SIGNBYCERT()` signatures from SQL Server 20163

sql-server-2016

NReilinghNReilingh

How do I write "proper" cursors?1

sql-server

HannahHannah

9`CURSOR_STATUS` provides a nice way of ensuring the cursor is ready and contains rows.

Hannah

JSONB: text contains array value?

postgresql

Anonymous 1800Anonymous 1800

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

Truilus

Breaking infinite loop in recursive CTE25

sql-server

artaxerxeartaxerxe

8Jack's solution is good for scenarios where loops can only be encountered at the beginning of traversing the hierarchies.

Andriy M

4With a slightly simplified case:

Jack Douglas

Show me the median! Show me the Mediaaan! Shooow meee the Meediaaaan! =D9

mysql

anoldmanintheseaanoldmaninthesea

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

Get the table start date and end date find the week date

mysql

rameshramesh

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