Re: SQL syntax - Mailing list pgsql-sql
From | Cedric Dufour (Cogito Ergo Soft) |
---|---|
Subject | Re: SQL syntax |
Date | |
Msg-id | NDBBIFNBODNADCAOFDOAMEKLCDAA.cedric.dufour@cogito-ergo-soft.com Whole thread Raw |
In response to | SQL syntax (frederic massot <frederic@juliana-multimedia.com>) |
List | pgsql-sql |
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 >