Re: Query Advice - Mailing list pgsql-sql

From David G. Johnston
Subject Re: Query Advice
Date
Msg-id CAKFQuwbto5hNVhPqKL3acJMbdTHLHb3-5T1UbBsBf0YTcOGY5w@mail.gmail.com
Whole thread Raw
In response to Query Advice  (Gary Chambers <gwchamb@gwcmail.com>)
Responses Re: Query Advice  (Rob Sargent <robjsargent@gmail.com>)
Re: Query Advice  (Gary Chambers <gwchamb@gwcmail.com>)
Re: Query Advice  (Gary Chambers <gwc@gwcmail.com>)
List pgsql-sql
On Thu, Mar 30, 2017 at 11:03 AM, Gary Chambers <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.

pgsql-sql by date:

Previous
From: Gary Chambers
Date:
Subject: Query Advice
Next
From: Vincent Elschot
Date:
Subject: Re: Query Advice