Re: quoting of array elements + sexp_out? - Mailing list pgsql-general

From Thien-Thi Nguyen
Subject Re: quoting of array elements + sexp_out?
Date
Msg-id E19fi6m-00030Z-00@colo.agora-net.com
Whole thread Raw
In response to Re: quoting of array elements + sexp_out?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
   Date: Thu, 24 Jul 2003 11:09:41 -0400
   From: Tom Lane <tgl@sss.pgh.pa.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

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: SAP DB: The unsung Open Source DB
Next
From: nolan@celery.tssi.com
Date:
Subject: Re: psql -e