Need help handling NULLs in PostgreSQL1

postgresql-15

Evan845Evan845

3Well, that's a NULL _value_ not the the string `'null'`. You need to just set the value to an empty string. Calling `replace()` on a NULL value, won't change anything. The replace() on the string `null` doesn't really make sense either. You can combine both conditions:

Truilus

How to implement a relationship between 2 tables where the type of participation is mandatory and RESTRICT rule for both?

postgresql

torarittetoraritte

Why isn't an Index Only Scan used on a partition accessed via the parent table?1

postgresql-14

Jack DouglasJack Douglas

3Well, you ask it to check `part_id`, don't you, and it's not a part of your index, so the row has to be accessed.

Anonymous 3091

XML/XPATH with unknown namespaces1

postgresql

TruilusTruilus

2`[local-name() = "Value"]` works for me:

Jack Douglas

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