Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id AD85D47618A
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 13:29:52 -0400 (EDT)
Received: from beamish.nsd.ca (unknown [205.150.156.194])
	by postgresql.org (Postfix) with ESMTP id C0ECB475BDB
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 13:29:48 -0400 (EDT)
Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id NAA23487;
	Tue, 6 Aug 2002 13:29:36 -0400
X-Authentication-Warning: beamish.nsd.ca: smap set sender to <jllachan@nsd.ca>
	using -f
Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap
	(V2.1/2.1+anti-relay+anti-spam)
	id xma023483; Tue, 6 Aug 02 13:29:22 -0400
Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148])
	by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id NAA04532;
	Tue, 6 Aug 2002 13:29:22 -0400
Message-ID: <3D500991.78527FD5@nsd.ca>
Date: Tue, 06 Aug 2002 13:38:25 -0400
From: Jean-Luc Lachance <jllachan@nsd.ca>
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: frederic massot <frederic@juliana-multimedia.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL syntax
References: <3D4FEB4C.3D4D06ED@juliana-multimedia.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/111
X-Sequence-Number: 8957

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