On 04/11/2018 16:54, Tom Lane wrote: > I looked into SQL:2011 to see what it has to say about this. In > 10.4 <routine invocation>, syntax rule 9) g) iii) says > > For each SQL parameter Pi, 1 (one) ≤ i ≤ SRNP, that is an output SQL > parameter or both an input SQL parameter and an output SQL parameter, > XAi shall be a <target specification>. > > The immediately preceding rules make it clear that XAi is the actual > argument corresponding to parameter Pi *after* default-insertion and > named-argument reordering. So our existing behavior here clearly > contradicts the spec: DEFAULT is not a <target specification>.
Note that parameter defaults with output parameters was only added in SQL:2016. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services