greater than vs between in where clause - Mailing list pgsql-general

From Yambu
Subject greater than vs between in where clause
Date
Msg-id CALhHtcATeM5BTrN6DPZgN8L+fhMgiAmoxKt-VqTFAiu6NJTiTg@mail.gmail.com
Whole thread Raw
Responses Re: greater than vs between in where clause  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
May i know if there is a difference in speed between 1 ,2 and 3 below , if column start_date is indexed

1.  select * from table_1 where start_date > '1 Oct 2020'
2. select   * from table_1 where start_date between '1 Oct 2020' and now()
3. select * from table_1 where start_date between '1 Oct 2020' and '5 Nov 2020 23:59:59'

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Large index
Next
From: Adrian Klaver
Date:
Subject: Re: greater than vs between in where clause