FIND YOUR NEXT FEW LINES
Results for “own”
Small, practical examples. Search by task or narrow things down below.
205 snippets foundClear filters
Insert or update on a key conflict
Use a unique key to update an existing row.
ON CONFLICT✓ Tested
Inspect deleted rows
Return values from the rows a DELETE removes.
DELETE✓ Tested
Join text rows in a chosen order
Combine values using string_agg.
string_agg✓ Tested
Label a volume with its purpose
Docker / Compose: Volume labels support explicit ownership and selection.
Docker / Compose✓ Tested
Make a Compose service’s filesystem read-only
Docker / Compose: Make a Compose service’s filesystem read-only in a small Compose file.
Docker / Compose✓ Tested
Match a text prefix
SQL: Use a percent wildcard after a known prefix.
SQL✓ Tested
Match a text prefix
SQL Server: Use a percent wildcard after a known prefix.
SQL Server✓ Tested
Match a text prefix
Postgres: Use a percent wildcard after a known prefix.
Postgres✓ Tested
Match a text prefix
SQLite: Use a percent wildcard after a known prefix.
SQLite✓ Tested
Number rows within each group
Assign ordered row numbers with a window function.
row_number✓ Tested
Raise and catch a domain-specific exception
Python: Give a validation failure its own exception type so callers can handle it narrowly.
Python✓ Tested
Read a JSONB field as text
Extract a nested value from a JSON document.
jsonb✓ Tested