Subject: Re: Query Advice
To: pgsql-sql@postgresql.org
References: <alpine.DEB.2.20.1703301350250.17355@websrv.gogca.com>
 <CAKFQuwbto5hNVhPqKL3acJMbdTHLHb3-5T1UbBsBf0YTcOGY5w@mail.gmail.com>
From: Rob Sargent <robjsargent@gmail.com>
Message-ID: <931ab9ce-a6e0-1722-ef90-22b4c8ea94a0@gmail.com>
Date: Thu, 30 Mar 2017 12:17:20 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.4.0
MIME-Version: 1.0
In-Reply-To: 
 <CAKFQuwbto5hNVhPqKL3acJMbdTHLHb3-5T1UbBsBf0YTcOGY5w@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------3DC6B0BAD5BF35130D3F0722"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------3DC6B0BAD5BF35130D3F0722
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit


On 03/30/2017 12:13 PM, David G. Johnston wrote:
> On Thu, Mar 30, 2017 at 11:03 AM, Gary Chambers <gwchamb@gwcmail.com 
> <mailto:gwchamb@gwcmail.com>>wrote:
>
>     Is there a better way to get the company information along with
>     all of the
>     addresses in a single query?  This works, but it requires the
>     additional
>     step of splitting the addresses by the the delimiter at the
>     application
>     layer.
>
>
> ​To comment as to "better" without any knowledge of the "application 
> layer" doesn't make sense.​
>
> I suggest you provide an example of what you'd like the output to look 
> like independent of any query concerns.
>
> ​David J.
>
If we assume the client layer is splitting by the pipe, why not just 
send the set of addresses and the client simply iterates over that, no 
hokey parsing involved.

--------------3DC6B0BAD5BF35130D3F0722
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p><br>
    </p>
    <br>
    <div class="moz-cite-prefix">On 03/30/2017 12:13 PM, David G.
      Johnston wrote:<br>
    </div>
    <blockquote
cite="mid:CAKFQuwbto5hNVhPqKL3acJMbdTHLHb3-5T1UbBsBf0YTcOGY5w@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div class="gmail_default"
          style="font-family:arial,helvetica,sans-serif"><span
            style="font-family:arial,sans-serif">On Thu, Mar 30, 2017 at
            11:03 AM, Gary Chambers </span><span dir="ltr"
            style="font-family:arial,sans-serif">&lt;<a
              moz-do-not-send="true" href="mailto:gwchamb@gwcmail.com"
              target="_blank">gwchamb@gwcmail.com</a>&gt;</span><span
            style="font-family:arial,sans-serif"> wrote:</span><br>
        </div>
        <div class="gmail_extra">
          <div class="gmail_quote">
            <blockquote class="gmail_quote" style="margin:0px 0px 0px
              0.8ex;border-left:1px solid
              rgb(204,204,204);padding-left:1ex">Is there a better way
              to get the company information along with all of the<br>
              addresses in a single query?  This works, but it requires
              the additional<br>
              step of splitting the addresses by the the delimiter at
              the application<br>
              layer.<br>
            </blockquote>
            <div><span style="font-family:arial,helvetica,sans-serif"><br>
              </span></div>
            <div><span style="font-family:arial,helvetica,sans-serif">​To
                comment as to "better" without any knowledge of the
                "application layer" doesn't make sense.</span><span
                style="font-family:arial,helvetica,sans-serif">​</span><br>
            </div>
            <div><br>
            </div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">I suggest
              you provide an example of what you'd like the output to
              look like independent of any query concerns.</div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif"><br>
            </div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif">​David J.</div>
            <div class="gmail_default"
              style="font-family:arial,helvetica,sans-serif"><br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    If we assume the client layer is splitting by the pipe, why not just
    send the set of addresses and the client simply iterates over that,
    no hokey parsing involved.<br>
  </body>
</html>

--------------3DC6B0BAD5BF35130D3F0722--