Re: Cosmetically-varying casts added to view definitions

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cosmetically-varying casts added to view definitions
Date: 2018-07-30 23:57:48
Message-ID: CAD3a31VCsQZY8_BSyT7ETPp0t-0zfCodU86vWKnZZEc2zM8Svg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 30, 2018 at 4:52 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 07/30/2018 04:29 PM, Ken Tanzer wrote:
> > On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>
> > Thanks Adrian. I do have what are supposed to be the original view
> > definitions, but I'm less than 100% confident they are accurate and
> > up-to-date, which is why I thought to use the actual definitions as
> > stored. Might have to rethink that one though, or just take a leap of
> > faith that the views will functionally be the same!
>
> Or write a test or tests to verify they are the same.
>

How would you do that exactly? I can see verifying that they return the
same rows given existing data, but not that this would be true with
different data.

Did you mean comparing the returned results, writing some view-specific
tests on a case-by-case basis, or something way way better that I'm not
grasping?

Thanks!

Ken

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-31 00:22:58 Re: Cosmetically-varying casts added to view definitions
Previous Message Adrian Klaver 2018-07-30 23:52:10 Re: Cosmetically-varying casts added to view definitions