Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group