duckweb_redirect

scalar · LOAD duckweb

duckweb_redirect(INTEGER, VARCHAR, VARCHAR) -> VARCHAR

A complete redirect response.

SELECT duckweb_redirect(303, '/notes', '')
FROM duckweb_match(route, '/notes') WHERE method = 'POST'

Status line, Location, Connection: close, the extra block, and Content-Length: 0. A redirect has no body, so there is nothing to stream and nothing to terminate — do not follow it with duckweb_end.

303 See Other after a POST is the pattern worth internalising: it makes the back button re-fetch the listing instead of resubmitting the form.

status is clamped to 100–599, and extra is filtered exactly as in duckweb_head.