Re: [GENERAL] PostgreSQL 9.2, SQL functions' named vs numbered parameters.

2012-06-13 Thread Tom Lane
Chris Travers 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

Re: [GENERAL] PostgreSQL 9.2, SQL functions' named vs numbered parameters.

2012-06-13 Thread Pavel Stehule
2012/6/13 Chris Travers : > Hi; > > In another thread it has been mentioned that SQL language functions in > 9.2 will accept named parameters and that you can't mix named and > numbered parameters.  Can anyone confirm this?   I am a bit concerned > this will break a lot of LSMB stored procedures an

[GENERAL] PostgreSQL 9.2, SQL functions' named vs numbered parameters.

2012-06-13 Thread Chris Travers
Hi; In another thread it has been mentioned that SQL language functions in 9.2 will accept named parameters and that you can't mix named and numbered parameters. Can anyone confirm this? I am a bit concerned this will break a lot of LSMB stored procedures and that we won't be able to support 8.