Possible to have named parameters in PreparedStatements?

[jc866]

Hello,
I like PreparedStatements over "normal/simple" queries. But I also much prefer named parameters over $1 $2... which can be confusing when modifying a query with many params, reordering them, etc.
Is it possible to have a mix of the two: named parameters transparently replaced by $1 $2 upon execution?
Thanks!

[vitaly-t]

Prepared Statements are by definition formatted by the server, not by the client, so NO, you cannot combine Prepared Statements with Named Parameters.

[jc866]

Thanks for your quick answer. But I was suggesting replacing names with numbers before sending the query to the server. This is what my current library in Delphi (I know) is doing and it's very convenient, prevents a lot of errors.

[vitaly-t]

This library doesn't support anything like that. Besides, Named Parameters have advanced syntax, with support for filters + custom type formatting, none of which can be converted into indexed variables.

[jc866]

Yes, I get the point. Thanks again for you quick and clear answer.