2011/3/27 Martijn van Oosterhout <klep...@svana.org>: > On Sun, Mar 27, 2011 at 06:52:03PM +0200, Pavel Stehule wrote: >> Syntax for named parameters should be consistent with prepared >> statement. Is there any comments in standard? > > Well, there's section 4.24 which says: > > "In SQL-statements that are executed dynamically, the parameters are > called dynamic parameters (<dynamic parameter specification>s) and are > represented in SQL language by a <question mark> (?)." >
ok, so my preferences: 1. no prefix - using a qualified identifiers - it's consistent with plpgsql and sql/psm 2 :name - it uses a Oracle and it can help to people who migrate from Oracle 3. $name - it is like enhancing of $number parameters - lot of languages uses this notation Regards Pavel Stehule > which I think we can all agree is not a useful guide. > > Have a nice day, > > -- > Martijn van Oosterhout <klep...@svana.org> http://svana.org/kleptog/ >> Patriotism is when love of your own people comes first; nationalism, >> when hate for people other than your own comes first. >> - Charles de Gaulle > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > > iD8DBQFNj2+UIB7bNG8LQkwRAjGeAJ99K0Zrp1EM/ike6h+cL5ZEH1Lb2QCfY28L > 7ETpiWfLtD90ISCVMvEgaSs= > =YEx2 > -----END PGP SIGNATURE----- > > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers