Re: Check Code Correction Current Period Prior Period Movement - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Check Code Correction Current Period Prior Period Movement
Date
Msg-id 6bee67fa-7742-4683-b20e-ad301f8ac14a@aklaver.com
Whole thread Raw
In response to Check Code Correction Current Period Prior Period Movement  (Anthony Apollis <anthony.apollis@gmail.com>)
List pgsql-general
On 11/23/23 06:02, Anthony Apollis wrote:
> Please assist me?
> I am trying to calculate
>   Current Period      Prior Period      Movement
> 
> from my data, the date columns are:
> image.png
> 
> Please check my code for any errors, code runs, i just want to make sure 
> it does what it's supposed to do.

Since you have not specified '...what it's supposed to do' is there is 
really not much that can be said. Your best bet is to create some sample 
input data and expected output and then create a test that verifies that 
the input passes through the view statements and ends up as the expected 
output.

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore enhancements
Next
From: Ron Johnson
Date:
Subject: Re: pg_restore enhancements