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

From Pavel Stehule
Subject Re: named parameters in SQL functions
Date
Msg-id 162867790911151116o322d5844l8c4bb542424f69ad@mail.gmail.com
Whole thread Raw
In response to Re: named parameters in SQL functions  (Andrew Chernow <ac@esilo.com>)
List pgsql-hackers
2009/11/15 Andrew Chernow <ac@esilo.com>:
>
>>> 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.
>

single character is my preference too.

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


pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: named parameters in SQL functions
Next
From: Heikki Linnakangas
Date:
Subject: Re: Summary and Plan for Hot Standby