On 28/05/10 19:19, Josh Berkus wrote:
> ( parameter := value ) notation is not only consistent with what is used
> inside pl/pgsql, it's also more consistent than "AS" with SQL Server's
> named parameter notation, which is:
>
> EXEC dbo.GetItemPrice @ItemCode = 'GXKP', @PriceLevel = 5
>
> Since former SQL Server / Sybase apps are the most likely to use named
> parameter notation in PostgreSQL, having a syntax which could be ported
> using only "sed" would be nice.
Once you solve the problem of finding the '='s in the source, replacing
them is exactly the same effort regardless of what you replace them with.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com