Re: Need feedback on new feature (\for) - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Need feedback on new feature (\for)
Date
Msg-id 200308250129.h7P1T5524491@candle.pha.pa.us
Whole thread Raw
In response to Re: Need feedback on new feature (\for)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Need feedback on new feature (\for)  (Martijn van Oosterhout <kleptog@svana.org>)
List 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: "Jenny -"
Date:
Subject: LOCK.tag(figuring out granularity of lock)--
Next
From: Justin Tocci
Date:
Subject: How do I find what views depend on a particular table?