On 04/03/2018 09:40 AM, hmidi slim wrote:
I tried insert into availability values ('product x',
'[2018-02-02,2018-03-01]'::daterange); and I got the same result such
as insert into availability values ('product x', daterange('2018-02-02',
'2018-03-01', '[]').
Yes, those are equivalent ways of
HI,
I tried* insert into availability values ('product x',
'[2018-02-02,2018-03-01]'::daterange); *and I got the same result such as*
insert into availability values ('product x', daterange('2018-02-02',
'2018-03-01', '[]').*
On 04/03/2018 07:35 AM, hmidi slim wrote:
I tried it and I got the same result.
Tried what?
--
Adrian Klaver
adrian.kla...@aklaver.com
I tried it and I got the same result.
hmidi slim writes:
> When I insert a data into this table I use this query:
> insert into availability values ('product x', daterange('2018-02-02',
> '2018-03-01', '[]')
> So I get a period like this: [2018-02-02, 2018-03-02)
Yup.
> In my app I tried to subtract a day from the period when I got
Hi,
I have a table* availability* which contains 3 columns: * id, product_id
and period_availability(type daterange).*
When I insert a data into this table I use this query:
insert into availability values ('product x', daterange('2018-02-02',
'2018-03-01', '[]')
So I get a period like this: [201
