| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: info about patch: using parametrised query in psql |
| Date: | 2009-12-25 19:12:43 |
| Message-ID: | 8393.1261768363@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> If we do want to go
> with a single flag character, maybe it should just be a single or
> double quote:
> :'foo - quote as a literal
> :"foo - quote as an ident
I would've proposed that myself if I thought it would work, but I'm
afraid that it will wreak complete chaos from a parsing standpoint.
Half the tools in the world will think this is an incomplete literal,
and I'm not even very sure you could keep psql itself from getting
confused.
Hmm ... actually, though, what about combining the ideas:
:'foo' - quote as a literal
:"foo" - quote as an ident
This leaves us with nothing much as far as extensibility, but from
a mnemonic standpoint it's a large win.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2009-12-25 19:12:58 | Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates |
| Previous Message | Pavel Stehule | 2009-12-25 19:09:36 | Re: info about patch: using parametrised query in psql |