query.sql.go

// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.26.0
// source: query.sql

package querytest

import (
	"context"
)

const cTEMultipleRefs = `-- name: CTEMultipleRefs :one
WITH t1_ids AS (
    SELECT id FROM t1 WHERE t1.id = $1
),
t2_ids AS (
    SELECT id FROM t2 WHERE t2.id = $1
),
all_ids AS (
    SELECT id FROM t1_ids
    UNION
    SELECT id FROM t2_ids
)
SELECT id FROM all_ids AS ids WHERE ids.id = $1
`

func (q *Queries) CTEMultipleRefs(ctx context.Context, id int32) (int32, error) {
	row := q.db.QueryRow(ctx, cTEMultipleRefs, id)
	err := row.Scan(&id)
	return id, err
}

const cTERef = `-- name: CTERef :one
WITH t1_ids AS (
    SELECT id FROM t1
)
SELECT id FROM t1_ids WHERE t1_ids.id = $1
`

func (q *Queries) CTERef(ctx context.Context, id int32) (int32, error) {
	row := q.db.QueryRow(ctx, cTERef, id)
	err := row.Scan(&id)
	return id, err
}