Empty Fields Aren't NULL

[nofue]

Submitting a form with a field with no content doesn't trigger the AS DEFAULT for the NOT NULL column but instead gives a "NOT NULL CONSTRAINT" error.

PostgreSQL 15
SQLPage 0.37.1

[lovasoa]

Hi! Yes, that's how SQL works. NULL and the empty string are distinct and need to be handled separately.

You can use CASE... WHEN to insert a default value instead of the empty string

INSERT INTO users (name)
VALUES (
  CASE $name WHEN '' THEN 'anonymous' ELSE  $name END
);