User defined types

From: Reza Shanbehbazari Mirzaei <mirzaei(at)stud(dot)ntnu(dot)no>
To: pgsql-sql(at)postgresql(dot)org
Subject: User defined types
Date: 2004-11-20 16:35:33
Message-ID: Pine.LNX.4.58.0411201729220.32082@jaguar.stud.ntnu.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-11-20 16:36:54 Re: Move table between schemas
Previous Message Rodrigo Carvalhaes 2004-11-20 15:54:15 Re: How to get the max on a char column?