pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: bugfix: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean"
Date: Mon, 5 Nov 2018 10:22:51 +0100
Message-ID: <e67e293e-4fd3-c25d-69b6-8daebbb6d1cf@2ndquadrant.com> (raw)
In-Reply-To: <7102.1541346845@sss.pgh.pa.us>
References: <CAFj8pRA6UsujpTs9Sdwmk-R6yQykPx46wgjj+YZ7zxm4onrDyw@mail.gmail.com>
	<CAFj8pRBdNqq8+SsChS8F5s9ttkdBSTPu=cq-fLx51FF7Tk_LkA@mail.gmail.com>
	<CAFj8pRCF3pia7gScM0jh7vY9rEuqN7fbnUV+jymRTLEXZeRDNA@mail.gmail.com>
	<CAFj8pRD2=MGU8ZshvmCjv5KG+3EngRm0+8pFLsjhG5bUhUGU2Q@mail.gmail.com>
	<CAFj8pRCehpRXn2vSq8Q+dQL2sQ0XXt0rOukFb0tZ5F7RFdH+DA@mail.gmail.com>
	<1d846492-3822-616b-7246-91b429cc5dbb@2ndquadrant.com>
	<CAFj8pRB3ZPu_SUDamXGA+wXw2aMmn0oLmgvsdMT1oAyJUMgFZA@mail.gmail.com>
	<26116.1541278051@sss.pgh.pa.us>
	<28551.1541281624@sss.pgh.pa.us>
	<CAFj8pRDUL=nC62L-AKKFDEo1en1ZT1otLfPdXkCjm8MHxif8PA@mail.gmail.com>
	<7102.1541346845@sss.pgh.pa.us>

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




view thread (18+ messages)  latest in thread

Message-ID: <e67e293e-4fd3-c25d-69b6-8daebbb6d1cf@2ndquadrant.com>
Permalink:  ../e67e293e-4fd3-c25d-69b6-8daebbb6d1cf@2ndquadrant.com/
Also on:    postgresql.org/message-id/e67e293e-4fd3-c25d-69b6-8daebbb6d1cf@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: peter.eisentraut@2ndquadrant.com, tgl@sss.pgh.pa.us, pavel.stehule@gmail.com
  Subject: Re: bugfix: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean"
  In-Reply-To: <e67e293e-4fd3-c25d-69b6-8daebbb6d1cf@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox