On Nov 5, 2007, at 11:58 AM, John DeSoi wrote:
Is there any feasibility to the idea of allowing pl/pgsql variables and parameters to be prefixed with a special character like '$'? I'm constantly adding prefixes like 'v_' because of conflicts with table or column names. It would be nice to have something like "declare $myvar integer;" so it would be very easy to distinguish variable and parameter names from structure names or reserved words.
+528,382 ;)At least in 8.3, IIRC you can safely use the name of the function to refer to variables, but it would be very nice if you could just do $blah in embedded SQL statements.
While we're talking about plpgsql... is there a TODO to allow RAISE to take a variable instead of just a fixed string? Yes, I can always do RAISE '%', variable, but then I lose % expansion.
-- 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
