Received: from news.tht.net (news.hub.org [216.126.91.242]) by hub.org (8.10.1/8.10.1) with ESMTP id e66LLgW36683 for ; Thu, 6 Jul 2000 17:21:42 -0400 (EDT) Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id QAA60416 for pgsql-sql@postgresql.org; Thu, 6 Jul 2000 16:57:48 -0400 (EDT) (envelope-from news) X-Authentication-Warning: news.tht.net: news set sender to using -f From: epa@post.cybercity.dk (Ebbe Poulsen) X-Newsgroups: comp.databases.postgresql.sql Subject: Get: Month & Month-1 & Month+1 Date: Thu, 06 Jul 2000 20:59:07 GMT Organization: CyberCity Internet Lines: 14 Message-ID: <3964f21a.8912408@news.cybercity.dk> X-Trace: news.cybercity.dk 962917065 79574 212.242.45.253 (6 Jul 2000 20:57:45 GMT) X-Complaints-To: abuse@cybercity.dk X-Newsreader: Forte Free Agent 1.21/32.243 To: pgsql-sql@postgresql.org X-Archive-Number: 200007/81 Hi, E.g. : The user/customer writes December, and I want to give back the plants flowering in November + December + January. (A circular situation, a 'season' covering more the one calender year in two cases ) The flowering field should be marked montly - in some convenient way: March-May , April-August etc - but which way. How could this job be done. -- Regards, Ebbe Poulsen, epa @post.cybercity.dk