Re: Need feedback on new feature (\for)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need feedback on new feature (\for)
Date: 2003-08-25 01:29:05
Message-ID: 200308250129.h7P1T5524491@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> I said:
> > ... I think it makes much more sense to push the
> > complexity into the control query and keep the substitution rules
> > non-surprising.
>
> BTW, taking that approach as gospel, we could forget my idea of
> declaring datatypes for the control-query results. Just substitute
> 'em literally. The quoting transformations could be done easily in
> the control query with quote_literal() or quote_ident().

Has the patch author looked at how psql variables adds quotes, usually
like:

"\"":var"\""

It is ugly, but it seems like the clearest way.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rifki 2003-08-25 01:43:26 support for OO query
Previous Message Bupp Phillips 2003-08-25 00:19:52 What is the fastest way to get a resultset