Re: range of composite types!

2022-04-26 Thread David G. Johnston
On Tuesday, April 26, 2022, Jian He wrote: > > -- composite type range. >> create type mytype as (t1 int, t2 date); >> -- create type my_interval as (t1 int, t2 interval); >> select (2,'2022-01-02')::mytype ; >> create type mytyperange as range(subtype = mytype); >> > > I am thinking construct a

range of composite types!

2022-04-26 Thread Jian He
range of composite types. I found this would be a great idea!!! Question on stackoverflow <https://stackoverflow.com/questions/71996169/some-of-range-composite-type-operator-only-check-the-elements-of-composite-type> DB Fiddle <https://dbfiddle.uk/?rdbms=postgres_