Re: named parameters in SQL functions - Mailing list pgsql-hackers

From Andrew Chernow
Subject Re: named parameters in SQL functions
Date
Msg-id 4B0052F4.7040502@esilo.com
Whole thread Raw
In response to Re: named parameters in SQL functions  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: named parameters in SQL functions
List pgsql-hackers
>> I like the special marker idea.  A '$' would be nice because its already in
>> use for similar purposes, but I think that would lead to ambiguity with
>> dollar quoting.
> 
> no, it should be safe (if you don't use for dollar quoting some like
> $variablename$)
> 

Actually, I was thinking of something like $abc$def, where abc and def are 
variables.  Although, this is much less likely than column name conflicts.

Other possibles are: $(var), @var@, or %var%.  I'd perfer a single character 
marker but that may not fly.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: named parameters in SQL functions
Next
From: Pavel Stehule
Date:
Subject: Re: named parameters in SQL functions