Date: Thu, 30 Mar 2017 15:22:12 -0400 (EDT)
From: Gary Chambers <gwchamb@gwcmail.com>
To: PostgreSQL SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Query Advice
In-Reply-To: 
 <CAKFQuwbto5hNVhPqKL3acJMbdTHLHb3-5T1UbBsBf0YTcOGY5w@mail.gmail.com>
Message-ID: <alpine.DEB.2.20.1703301521280.17355@websrv.gogca.com>
References: <alpine.DEB.2.20.1703301350250.17355@websrv.gogca.com>
 <CAKFQuwbto5hNVhPqKL3acJMbdTHLHb3-5T1UbBsBf0YTcOGY5w@mail.gmail.com>
User-Agent: Alpine 2.20 (DEB 67 2015-01-07)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Gentlemen,

Thank you for your replies.

I'm working on a Python Flask web application.

> 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.

"Better" is to have the results returned without having the address columns
delimited by some character.  The simple join that Jason suggested is
definitely sufficient, but it seems like returning the repeating name column
is unnecessary.

My question is really more theoretical than anything else.  Vincent's
suggestion to return JSON is probably the closest to what I am trying to
accomplish.  My ultimate goal is to have the equivalent of a Python list of
dictionaries as addresses, though the keys aren't a requirement as long as I
can define the order of the columns and avoid using the delimiter.

That being said, how would I accomplish this and return the data in the
usual SQL results format without using concat_ws()?

Thank you, again, for your advice.

--
G.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql