Postgres Pro
Downloads
Home   >   mailing lists

Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range - Mailing list pgsql-sql

From nikhil raj
Subject Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
Date
Msg-id CAG1ps1wWWGS1bai_N5n-aJzTQ7Efv9WR37OPAydnT1MBqbrZBQ@mail.gmail.com
Whole thread Raw
Responses Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range.  (nikhil raj <nikhilraj474@gmail.com>)
Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range  (Steve Midgley <science@misuse.org>)
List pgsql-sql
Tree view

Hi All,

Need help in rotation of data in Postgres.

There is a table called crew_details

enter image description here

There is a requirement to rotate the crew members for in weekly or on the every 7th day and continue for rest 6days the same order of for the given date range un till it reach end date . and the expected output should be like this below

>

Please can any one help me in in the rotation in postgres SQL

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Could not serialize access due to read/write dependencies among transactions
Next
From: nikhil raj
Date:
Subject: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range.