Re: SQL syntax

I would try something like

SELECT
(id_mois+12)%12
FROM
( SELECT id_mois-12 AS id_mois FROM mois
UNION
SELECT id_mois FROM mois
UNION
SELECT id_mois+12 AS id_mois FROM mois ) AS mois_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(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of frederic massot
> Sent: Tuesday, August 06, 2002 17:29
> To: pgsql-sql(at)postgresql(dot)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(at)juliana-multimedia(dot)com |
> ===========================Debian=GNU/Linux===
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>