Re: How to assemble all fields of (any) view into a string?

On Wed, Sep 7, 2016 at 4:31 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 9/7/2016 1:36 PM, Ken Tanzer wrote:
>
>> No transformation is needed, except for padding the fields out to their
>> maximum lengths.
>>
>
> without accessing metadata, how would you know what those maximum lengths
> are??
>

I agree you'd need metadata. My OP mentioned looking this up in the
information schema

>
> and how would the calling program even know what the fields are if its not
> aware of the field lengths?
>
> Do you mean how would the function know? I didn't see a better way than
by explicitly passing the view name.

> what if a field is type 'text' ? or an array type ?
>
>
They won't be. This has to work for a very specific set of views I've
created, not for any view in the universe!

Cheers,
Ken

>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://agency-software.org/demo/client
<https://agency-software.org/demo/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.