You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2015/10/27 23:41:27 UTC

[jira] [Commented] (CALCITE-941) Named parameter passing

    [ https://issues.apache.org/jira/browse/CALCITE-941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14977295#comment-14977295 ] 

Julian Hyde commented on CALCITE-941:
-------------------------------------

DB2 has supported this since 7.2; see http://www.ibm.com/developerworks/ibmi/library/i-sql-parameter-name-default-value/. Also note use of the DEFAULT keyword.

Also Postgres: see http://www.postgresql.org/docs/9.1/static/sql-createfunction.html and http://www.postgresql.org/docs/9.1/static/sql-syntax-calling-funcs.html. They use ":=" not "=>".

> Named parameter passing
> -----------------------
>
>                 Key: CALCITE-941
>                 URL: https://issues.apache.org/jira/browse/CALCITE-941
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>
> Investigate whether named parameter passing is in the SQL standard, and implement it in Calcite.
> See https://community.oracle.com/thread/482633?start=0&tstart=0 for an example.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)