Re: Why overlaps is not working
От | Matthias.Pitzl@izb.de |
---|---|
Тема | Re: Why overlaps is not working |
Дата | |
Msg-id | 11EC9A592C31034C88965C87AF18C2A70CFCDB@m0000s61 обсуждение исходный текст |
Ответ на | Why overlaps is not working ("Andrus" <eetasoft@online.ee>) |
Список | pgsql-general |
Hm, why not this one: select ('2006-10-31'::date, '9999-12-31'::date) OVERLAPS ('2006-10-16'::DATE, '2006-10-31':: DATE); overlaps ---------- f (1 row) Greetings, Matthias > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrus > Sent: Thursday, November 09, 2006 2:47 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Why overlaps is not working > > > set datestyle to iso,iso; > > select 1 where ('2006-10-31'::date, '9999-12-31'::date) OVERLAPS > ('2006-10-16'::DATE, '2006-10-31':: DATE) > > > does not return any rows. > > Why ? > How to make overlaps to return correct result? > > Andrus. > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > http://www.postgresql.org/docs/faq
В списке pgsql-general по дате отправления: