Makes sense yeah. Thanks for both of your help.
Raul Kontakt hubert depesz lubaczewski (<dep...@depesz.com>) kirjutas kuupäeval K, 5. veebruar 2020 kell 14:50: > On Wed, Feb 05, 2020 at 02:42:42PM +0200, Raul Kaubi wrote: > > Thanks, it worked! > > > > By the way, what does this "**j"* mean there..? (this does not mean > > multiply there?) > > it's normal multiplication. > > Your "j" variable is integer. > > So, '1 month'::interval * j is some number of months. > > And what if, I would like to declare v_to_date also, so that v_to_date is > > always + 1 month compared to v_date_from..? > > v_to_date := v_from_date + '1 month'::interval; ? > > Best regards, > > depesz > >
