Horton

Improve the error message for an inappropriate column definition list.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: ce90f075f0d831ca4085ba73891b7da2a2f7047e
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2020-09-22T14:49:11Z
Releases: 14.0 
Improve the error message for an inappropriate column definition list.

The existing message about "a column definition list is only allowed for
functions returning "record"" could be given in some cases where it was
fairly confusing; in particular, a function with multiple OUT parameters
*does* return record according to pg_proc.  Break it down into a couple
more cases to deliver a more on-point complaint.  Per complaint from
Bruce Momjian.

Discussion: https://postgr.es/m/798909.1600562993@sss.pgh.pa.us

Files

PathChange+/−
src/backend/parser/parse_relation.c modified +37 −7
src/test/regress/expected/rangefuncs.out modified +13 −0
src/test/regress/sql/rangefuncs.sql modified +5 −0

Discussion