Re: [SQL] [GENERAL] date range query help

2008-11-20 Thread Frank Bax
novice wrote: 2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>: On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote: sorry I get nothing :( Of course not. None of the dates you gave in the example overlap. But it should still have the 1st entry with the name Ben? Am

Re: [SQL] [GENERAL] date range query help

2008-11-19 Thread Joshua D. Drake
On Thu, 2008-11-20 at 15:41 +1100, novice wrote: > omg - how embarrassing. > so sorry :( > I note your name is novice. Don't sweat it. We are here to help. Joshua D. Drake -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://

Re: [SQL] [GENERAL] date range query help

2008-11-19 Thread Adam Rich
> >> sorry I get nothing :( > > > > Of course not. None of the dates you gave in the example overlap. > > > > But it should still have the 1st entry with the name Ben? Am I > missing something? Ben's issue dates are in the year 2008. The first call entry is in the year 2007. There are no cust

Re: [SQL] [GENERAL] date range query help

2008-11-19 Thread novice
omg - how embarrassing. so sorry :( 2008/11/20 brian <[EMAIL PROTECTED]>: > novice wrote: >> >> 2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>: >>> >>> On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> >>> wrote: sorry I get nothing :( >>> >>> Of course not. None of

Re: [SQL] [GENERAL] date range query help

2008-11-19 Thread brian
novice wrote: 2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>: On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote: sorry I get nothing :( Of course not. None of the dates you gave in the example overlap. But it should still have the 1st entry with the name Ben? Am

Re: [SQL] [GENERAL] date range query help

2008-11-19 Thread novice
2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>: > On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote: >> sorry I get nothing :( > > Of course not. None of the dates you gave in the example overlap. > But it should still have the 1st entry with the name Ben? Am I missing

Re: [SQL] [GENERAL] date range query help

2008-11-19 Thread Rodrigo E. De León Plicet
On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote: > sorry I get nothing :( Of course not. None of the dates you gave in the example overlap. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai