Re: Assigning values to a range in Pgsql and inclusive / exclusive bounds

Thanks for that perfect... missed the use of tstzrange() as a 'function' in the documentation. Best regards Ron On Fri, 12 Jun 2020 at 21:02, Adrian Klaver wrote: > On 6/12/20 11:45 AM, Ron Clarke wrote: > > Hi, > > > > I've got a simple problem, but I'm convinced that there must be an > > eleg

Re: Assigning values to a range in Pgsql and inclusive / exclusive bounds

On 6/12/20 11:45 AM, Ron Clarke wrote: Hi, I've got a simple problem, but I'm convinced that there must be an elegant solution. I'm a refugee from the world of MSSQL, so I'm still finding some aspects of PostgreSQL alien. I'm trying to use the /tstzrange /datatype. My issue is correctly set

Re: Assigning values to a range in Pgsql and inclusive / exclusive bounds

On 6/12/20 11:45 AM, Ron Clarke wrote: Hi, I've got a simple problem, but I'm convinced that there must be an elegant solution. I'm a refugee from the world of MSSQL, so I'm still finding some aspects of PostgreSQL alien. I'm trying to use the /tstzrange /datatype. My issue is correctly set

Assigning values to a range in Pgsql and inclusive / exclusive bounds

Hi, I've got a simple problem, but I'm convinced that there must be an elegant solution. I'm a refugee from the world of MSSQL, so I'm still finding some aspects of PostgreSQL alien. I'm trying to use the *tstzrange *datatype. My issue is correctly setting the bound types when assigning values to