cockroachdb / cockroachdb/cockroach
plpgsql: add support for declaring variable collation
Open
A-sql-plpgsql
C-enhancement
docs-done
docs-known-limitation
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Postgres PLpgSQL allows variables to be declared with an associated collation using the `COLLATE` keyword: https://www.postgresql.org/docs/current/plpgsql-declarations.html#PLPGSQL-DECLARATION-COLLATION
This issue tracks implementing this syntax.
Jira issue: CRDB-28937
Contributor guide
Research direction
Start by reading the linked PostgreSQL PL/pgSQL declaration-collation documentation and locating CockroachDB's PL/pgSQL declaration parsing and execution paths. The issue names no files or tests, so identify the relevant parser and existing declaration tests first; done means variable declarations using COLLATE are accepted and behave as documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, postgresql, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100