In 9.4.1, I do this:
CREATE TYPE my_test_type as (part1 text, part2 text);
\pset null NULL
WITH test_table(test_col) AS (
VALUES (NULL::my_test_type), (ROW(NULL, NULL)::my_test_type)
)
SELECT *, (test_col).part1, (test_col).part2, test_col IS NULL AS is_null FROM
test_table;
And I get this
On Mar 22, 2013, at 2:57 PM, Ryan Kelly wrote:
> On Fri, Mar 03/22/13, 2013 at 10:14:45AM -0600, Denver Timothy wrote:
>> In PostgreSQL 9.2.3 I am trying to create this simplified table:
>>
>>CREATE TABLE test (
>>user_id INTEGER,
>>star
In PostgreSQL 9.2.3 I am trying to create this simplified table:
CREATE TABLE test (
user_id INTEGER,
startend TSTZRANGE,
EXCLUDE USING gist (user_id WITH =, startend WITH &&)
);
But I get this error:
ERROR: data type integer has no default operator class for
