On Aug 20, 2008, at 8:26 AM, Pavel Stehule wrote:
2008/8/20 Tom Lane <[EMAIL PROTECTED]>:"Pavel Stehule" <[EMAIL PROTECTED]> writes:I understand now why Oracle use => symbol for named params. This isn'tused so operator - so implementation is trivial.You really didn't understand the objection at all, did you?The point is not about whether there is any built-in operator named =>. The point is that people might have created user-defined operators namedthat.I understand well, so only I don't see better solution. Yes, everyone who used => should have problems, but it is similar with .. new keywords, etc. Probably easy best syntax doesn't exist :(. I haven't idea who use => now and how often, and if this feature is possible in pg, but there are not technical barriers.
How about we poll -general and see what people say? I'll bet Tom a beer that no one replies saying they've created a => operator (unless maybe PostGIS uses it).
If we're really worried about it we can have a GUC for a few versions that turns off named parameter assignment. But I don't think we should compromise the design on the theory that some folks might be using that as an operator *and* can't change their application to wrap it's use in ().
-- Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature