Re: quoting of array elements + sexp_out?

From: Thien-Thi Nguyen <ttn(at)glug(dot)org>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: quoting of array elements + sexp_out?
Date: 2003-07-24 15:34:20
Message-ID: E19fi6m-00030Z-00@colo.agora-net.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Date: Thu, 24 Jul 2003 11:09:41 -0400
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

(a) So that numerics don't get quoted. (b) The original coding was
wrong, since its rule for deciding when to quote had nothing to do
with the contents of the string being quoted, and it could thus fail
to quote when quoting was essential.

hmm, if the goal is to not quote numerics, why not check for that class
of types explicitly instead of checking for embedded characters?
perhaps add a type attribute "needs quotes" or a typoutput function
attribute "produces quotes"? a scan of the contents could be avoided
entirely in this way.

thi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-07-24 15:36:05 Re: SAP DB: The unsung Open Source DB
Previous Message nolan 2003-07-24 15:33:55 Re: psql -e