This is not overloading of SQL command - it is like annotations. It is smart idea, so I was not surprised if ANSI/SQL reuses it.
SHas ANSI declared that they will NEVER support := in a SELECT that's not running in a stored function? Because if they haven't done that, there's nothing preventing them from doing just that. If that happens we're going to have some very difficult choices to make.
No, there is nothing declared in ANSI. But currently in ANSI is not using one operator for two different thing.
Regards
Pavel
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532)
