duckdb/pg_duckdb

Support more types in prepared statement

Open

#892 opened on Aug 20, 2025

View on GitHub
 (1 comment) (0 reactions) (0 assignees)C++ (183 forks)github user discovery
good first issuetypes

Repository metrics

Stars
 (3,125 stars)
PR merge metrics
 (Avg merge 60d 10h) (7 merged PRs in 30d)

Description

What happens?

While working on https://github.com/duckdb/pg_duckdb/pull/863, I noticed that several other data types, besides UUID, are currently unsupported in prepared statements

Specifically, those types exist in ConvertPostgresToDuckValue, but not in ConvertPostgresParameterToDuckValue: https://github.com/duckdb/pg_duckdb/blob/main/src/pgduckdb_types.cpp

To Reproduce

n/a

OS:

Linux

pg_duckdb Version (if built from source use commit hash):

55874e3

Postgres Version (if built from source use commit hash):

17.6

Hardware:

No response

Full Name:

Cheng Chen

Affiliation:

Mooncake Labs

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have not tested with any build

Did you include all relevant data sets for reproducing the issue?

Not applicable - the reproduction does not require a data set

Did you include all code required to reproduce the issue?

  • Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?

  • Yes, I have

Contributor guide

Research direction
Examine the ConvertPostgresParameterToDuckValue function in src/pgduckdb types.cpp and add the missing type conversions that are already handled in ConvertPostgresToDuckValue.
Tech stack
cppsql
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
C++Git
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65