Re: info about patch: using parametrised query in psql - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: info about patch: using parametrised query in psql
Date
Msg-id 162867790912251054u4a5c2032q9b6c3626a580db23@mail.gmail.com
Whole thread Raw
In response to Re: info about patch: using parametrised query in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2009/12/25 Tom Lane <tgl@sss.pgh.pa.us>:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> there are two quoting styles, so we need two syntax. I proposed
>
>> :[var] and :{var} - for ident quoting and literal quoting.
>> Theoretically we could to use :(var) for bytea escaping.
>
> And if you need a fourth style, you're at a dead end.  I don't think
> this is really an improvement over the single-flag-character approach.
> Neither one has got any mnemonic value whatever, unfortunately, but
> at least the flag character method is fairly extensible.

I thing so not.

what:

:'variable'
:"variable"

we could to use any non identifier char without ":"

for me - flag characters looks little bit strange - maybe I have a
quoting joined with some symmetric. Maybe it looks too much like unary
operator

Regards
Pavel

>
>                        regards, tom lane
>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates
Next
From: Pavel Stehule
Date:
Subject: Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates