Обсуждение: SQL syntax
Hello, I have a table containing the months of the year : travail=> select * from mois order by id_mois; id_mois|mois_fr |mois_en |mois_de -------+---------+---------+--------- 1|Janvier |January |Januar 2|Fevrier |February |Februar 3|Mars |March |Marz 4|Avril |April |April 5|Mai |May |Aber 6|Juin |June |Juni 7|Juillet |July |Juli 8|Aout |August |August 9|Septembre|September|September 10|Octobre |October |Oktober 11|Novembre |November |November 12|Decembre |December |Dezember (12 rows) And I try to obtain for one month given (for example August : 8) two previous months, the current month, and nine next months : id_mois|mois_fr |mois_en |mois_de -------+---------+---------+--------- 6|Juin |June |Juni 7|Juillet |July |Juli 8|Aout |August |August 9|Septembre|September|September 10|Octobre |October |Oktober 11|Novembre |November |November 12|Decembre |December |Dezember 1|Janvier |January |Januar 2|Fevrier |February |Februar 3|Mars |March |Marz 4|Avril |April |April 5|Mai |May |Aber Do you see how making in a SQL request ? Thank you. -- ============================================== | FREDERIC MASSOT | | http://www.juliana-multimedia.com | | mailto:frederic@juliana-multimedia.com | ===========================Debian=GNU/Linux===
On Tue, 6 Aug 2002, frederic massot wrote: > And I try to obtain for one month given (for example August : 8) two > previous months, the current month, and nine next months : > > > id_mois|mois_fr |mois_en |mois_de > -------+---------+---------+--------- > 6|Juin |June |Juni > 7|Juillet |July |Juli > 8|Aout |August |August > 9|Septembre|September|September > 10|Octobre |October |Oktober > 11|Novembre |November |November > 12|Decembre |December |Dezember > 1|Janvier |January |Januar > 2|Fevrier |February |Februar > 3|Mars |March |Marz > 4|Avril |April |April > 5|Mai |May |Aber > > Do you see how making in a SQL request ? given m = 8: select * from mois order by case when id_mois < (m + 10) % 12 then id_mois + 13 else id_mois end; -- Tod McQuillin
I would try something like SELECT(id_mois+12)%12 FROM( SELECT id_mois-12 AS id_mois FROM moisUNIONSELECT id_mois FROM moisUNIONSELECT id_mois+12 AS id_mois FROM mois ) ASmois_etendu WHERE( mois_etendu.id_mois >= (mon_mois-2) )AND( mois_etendu.id_mois <= (mon_mois+9) ) where 'mon_mois' is your reference month (e.g. 8) Cedric Dufour > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of frederic massot > Sent: Tuesday, August 06, 2002 17:29 > To: pgsql-sql@postgresql.org > Subject: [SQL] SQL syntax > > > Hello, > > I have a table containing the months of the year : > > > travail=> select * from mois order by id_mois; > > id_mois|mois_fr |mois_en |mois_de > -------+---------+---------+--------- > 1|Janvier |January |Januar > 2|Fevrier |February |Februar > 3|Mars |March |Marz > 4|Avril |April |April > 5|Mai |May |Aber > 6|Juin |June |Juni > 7|Juillet |July |Juli > 8|Aout |August |August > 9|Septembre|September|September > 10|Octobre |October |Oktober > 11|Novembre |November |November > 12|Decembre |December |Dezember > (12 rows) > > > And I try to obtain for one month given (for example August : 8) two > previous months, the current month, and nine next months : > > > id_mois|mois_fr |mois_en |mois_de > -------+---------+---------+--------- > 6|Juin |June |Juni > 7|Juillet |July |Juli > 8|Aout |August |August > 9|Septembre|September|September > 10|Octobre |October |Oktober > 11|Novembre |November |November > 12|Decembre |December |Dezember > 1|Janvier |January |Januar > 2|Fevrier |February |Februar > 3|Mars |March |Marz > 4|Avril |April |April > 5|Mai |May |Aber > > > Do you see how making in a SQL request ? > > Thank you. > -- > ============================================== > | FREDERIC MASSOT | > | http://www.juliana-multimedia.com | > | mailto:frederic@juliana-multimedia.com | > ===========================Debian=GNU/Linux=== > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Try: Order by mod( id_mois + 12 - <current_month>, 12) frederic massot wrote: > > Hello, > > I have a table containing the months of the year : > > travail=> select * from mois order by id_mois; > > id_mois|mois_fr |mois_en |mois_de > -------+---------+---------+--------- > 1|Janvier |January |Januar > 2|Fevrier |February |Februar > 3|Mars |March |Marz > 4|Avril |April |April > 5|Mai |May |Aber > 6|Juin |June |Juni > 7|Juillet |July |Juli > 8|Aout |August |August > 9|Septembre|September|September > 10|Octobre |October |Oktober > 11|Novembre |November |November > 12|Decembre |December |Dezember > (12 rows) > > And I try to obtain for one month given (for example August : 8) two > previous months, the current month, and nine next months : > > id_mois|mois_fr |mois_en |mois_de > -------+---------+---------+--------- > 6|Juin |June |Juni > 7|Juillet |July |Juli > 8|Aout |August |August > 9|Septembre|September|September > 10|Octobre |October |Oktober > 11|Novembre |November |November > 12|Decembre |December |Dezember > 1|Janvier |January |Januar > 2|Fevrier |February |Februar > 3|Mars |March |Marz > 4|Avril |April |April > 5|Mai |May |Aber > > Do you see how making in a SQL request ? > > Thank you. > -- > ============================================== > | FREDERIC MASSOT | > | http://www.juliana-multimedia.com | > | mailto:frederic@juliana-multimedia.com | > ===========================Debian=GNU/Linux=== > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Can someone *pleaaaaase* temporarely remove "Bob Powell" <Bob@hotchkiss.org> from the list so we do not get a vacation message for every message one posts. Jean-Luc Lachance wrote: > > Try: > > Order by mod( id_mois + 12 - <current_month>, 12) > > frederic massot wrote: > > > > Hello, > > > > I have a table containing the months of the year : > > > > travail=> select * from mois order by id_mois; > > > > id_mois|mois_fr |mois_en |mois_de > > -------+---------+---------+--------- > > 1|Janvier |January |Januar > > 2|Fevrier |February |Februar > > 3|Mars |March |Marz > > 4|Avril |April |April > > 5|Mai |May |Aber > > 6|Juin |June |Juni > > 7|Juillet |July |Juli > > 8|Aout |August |August > > 9|Septembre|September|September > > 10|Octobre |October |Oktober > > 11|Novembre |November |November > > 12|Decembre |December |Dezember > > (12 rows) > > > > And I try to obtain for one month given (for example August : 8) two > > previous months, the current month, and nine next months : > > > > id_mois|mois_fr |mois_en |mois_de > > -------+---------+---------+--------- > > 6|Juin |June |Juni > > 7|Juillet |July |Juli > > 8|Aout |August |August > > 9|Septembre|September|September > > 10|Octobre |October |Oktober > > 11|Novembre |November |November > > 12|Decembre |December |Dezember > > 1|Janvier |January |Januar > > 2|Fevrier |February |Februar > > 3|Mars |March |Marz > > 4|Avril |April |April > > 5|Mai |May |Aber > > > > Do you see how making in a SQL request ? > > > > Thank you. > > -- > > ============================================== > > | FREDERIC MASSOT | > > | http://www.juliana-multimedia.com | > > | mailto:frederic@juliana-multimedia.com | > > ===========================Debian=GNU/Linux=== > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> Can someone *pleaaaaase* temporarely remove
> "Bob Powell" <Bob@hotchkiss.org>
> from the list so we do not get a vacation message for every message one
> posts.
I complained to Marc about that a week or more ago, but I guess he
doesn't want to bounce Bob from the lists just for being incompetent
about configuring "vacation". I've set my own mailserver to deny
connections from hotchkiss.org ...
regards, tom lane
On Tue, Aug 06, 2002 at 23:31:49 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Jean-Luc Lachance <jllachan@nsd.ca> writes: > > Can someone *pleaaaaase* temporarely remove > > "Bob Powell" <Bob@hotchkiss.org> > > from the list so we do not get a vacation message for every message one > > posts. > > I complained to Marc about that a week or more ago, but I guess he > doesn't want to bounce Bob from the lists just for being incompetent > about configuring "vacation". I've set my own mailserver to deny > connections from hotchkiss.org ... He isn't using software appropiate as a vacation responder. It is responding to the wrong address. Delivery status messages (such as vacation messages) should go to the envelope sender address, not addresses in the message headers. The responder has replied to messages that didn't explicitly list his email address in the recipient headers (as well as having several other features indicating they were list messages rather than messages specifically for him). I also received several notifications from his bot over a couple of hours. Normally vacation bots don't send notices more than about once every two weeks.
Well.... It's Friday and I am still geting vacation messages from Bob.... Tom Lane wrote: > > Jean-Luc Lachance <jllachan@nsd.ca> writes: > > Can someone *pleaaaaase* temporarely remove > > "Bob Powell" <Bob@hotchkiss.org> > > from the list so we do not get a vacation message for every message one > > posts. > > I complained to Marc about that a week or more ago, but I guess he > doesn't want to bounce Bob from the lists just for being incompetent > about configuring "vacation". I've set my own mailserver to deny > connections from hotchkiss.org ... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster