Postgres Pro
Downloads
Home   >   mailing lists

proposal: ANSI SQL 2011 syntax for named parameters - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal: ANSI SQL 2011 syntax for named parameters
Date
Msg-id CAFj8pRD82DOVWYqN5vQ-4OEZu3jK-B5mFDMXJ4kKqGTV0sGjOw@mail.gmail.com
Whole thread Raw
Responses Re: proposal: ANSI SQL 2011 syntax for named parameters  (Peter Eisentraut <peter_e@gmx.net>)
Re: proposal: ANSI SQL 2011 syntax for named parameters  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
Hello

I am not sure, but maybe is time to introduce ANSI SQL syntax for
functions' named parameters

It is defined in ANSI SQL 2011

 CALL P (B => 1, A => 2)

instead PostgreSQL syntax CALL ( B := 1, A := 2)

Patch is very simple, but there are lot of questions about support
previous syntax.

* should we support both - probably yes

* how long time we will support pg syntax? - 2..5..ever years

* when we mark pg syntax as obsolete?

* when we remove pg syntax?

Regards

Pavel
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: enhanced error fields
Next
From: Peter Geoghegan
Date:
Subject: Re: pg_stat_statements: calls under-estimation propagation