Closed
Description
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?
Option 1: Add a parameter to the sqlc.arg
function
CREATE TABLE users ( name TEXT NOT NULL );
-- name: ListUsers :many
SELECT *
FROM users
WHERE name = sqlc.arg('name', nullable => true);
Originally reported in #200