User defined types - Mailing list pgsql-sql

From Reza Shanbehbazari Mirzaei
Subject User defined types
Date
Msg-id Pine.LNX.4.58.0411201729220.32082@jaguar.stud.ntnu.no
Whole thread Raw
Responses Re: User defined types
List pgsql-sql
 Hello:
 I have a user define type called VALID_TIME. It is declared as follows:
 CREATE TYPE VALID_TIME AS (t_s TIMESTAMP, t_e TIMESTAMP);
 Once I have used this in a table declaration, is it possible to extract
parts of it, for example to only read t_s or t_e? If so, how do I do this?
 Thank you. -Reza


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Explicitly rolling back transaction from within a C-Language function
Next
From: Dave Steinberg
Date:
Subject: PG7.4.5: query not using index on date column