Mark query parameters as nullable

For the following query, sqlc will generate a function signature with a string for parameter $1.

CREATE TABLE users ( name TEXT NOT NULL );

-- name: ListUsers :many
SELECT *
FROM users
WHERE name = $1;

func (q *Queries) ListUsers(ctx context.Context, name string) ([]string, error) {
    // ...
}

How should we indicate that parameter $1 should be nullable?

CREATE TABLE users ( name TEXT NOT NULL );

-- name: ListUsers :many
SELECT *
FROM users
WHERE name = sqlc.arg('name', nullable => true);

Originally reported in #200

Option 1 seems to be the best way to implement this feature.

how would you go about the shorthand for @param? new syntax? no shorthand?

@mrsufgi

@mrsufgi the shorthand syntax is problematic (see #605), so for now this would only work when using sqlc.arg.

Fixed by #1536

Navigation Menu