On Wed, Sep 7, 2016 at 4:31 PM, John R Pierce <pie...@hogranch.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@postgresql.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.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
