Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

[Dominique Devienne <ddevienne@xxxxxxxxx>]

On Tue, Jul 23, 2024 at 10:35 PM Adrian Klaver
<adrian.klaver@xxxxxxxxxxx> wrote:
> Just know that SQLite does not enforce types [...]

That's true, and applies to the OP's schema.

But for the record, SQLite *can* enforce types these days,
on an opt-in basis, with [STRICT tables][1].
Albeit with a limited type-system. --DD

PS: and could be done manually even before, with CHECK
(typeof(col)='blob') for example.

[1]: https://www.sqlite.org/stricttables.html