cockroachdb / cockroachdb/cockroach
plpgsql: support DEFAULT syntax in the declaration
Open
A-sql-plpgsql
A-sql-routine
C-cleanup
O-qa
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
This two definitions are equivalent, but we only currently support the latter:
```sql
DROP PROCEDURE IF EXISTS p;
CREATE PROCEDURE p() LANGUAGE PLpgSQL AS $$
DECLARE
var TEXT DEFAULT 'test';
BEGIN
RAISE NOTICE '%', var;
END;
$$;
```
```sql
DROP PROCEDURE IF EXISTS p;
CREATE PROCEDURE p() LANGUAGE PLpgSQL AS $$
DECLARE
var TEXT = 'test';
BEGIN
RAISE NOTICE '%', var;
END;
$$;
```
Jira issue: CRDB-37793
Contributor guide
Assessment
This issue has not been assessed yet.