Request a Demo
Home   >   mailing lists

Re: PostgreSQL 9.2, SQL functions' named vs numbered parameters. - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL 9.2, SQL functions' named vs numbered parameters.
Date
Msg-id 8786.1339595692@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL 9.2, SQL functions' named vs numbered parameters.  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
Tree view 
Chris Travers <chris.travers@gmail.com> writes:
> In another thread it has been mentioned that SQL language functions in
> 9.2 will accept named parameters

This is correct.

> and that you can't mix named and
> numbered parameters.

This is not correct.  You can reference a parameter either by its name
or its number, same as in plpgsql.

            regards, tom lane

pgsql-general by date:

Previous
From: Rob Cowell
Date:
Subject: Daisy chaining replication slaves ?
Next
From: Alban Hertroys
Date:
Subject: Re: Trying to execute several queries involving temp tables in a PHP script