pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Reza Shanbehbazari Mirzaei <mirzaei@stud.ntnu.no>
To: pgsql-sql@postgresql.org
Subject: User defined types
Date: Sat, 20 Nov 2004 17:35:33 +0100 (CET)
Message-ID: <Pine.LNX.4.58.0411201729220.32082@jaguar.stud.ntnu.no> (raw)


  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



view thread (2+ messages)  latest in thread

Message-ID: <Pine.LNX.4.58.0411201729220.32082@jaguar.stud.ntnu.no>
Permalink:  ../Pine.LNX.4.58.0411201729220.32082@jaguar.stud.ntnu.no/
Also on:    postgresql.org/message-id/Pine.LNX.4.58.0411201729220.32082@jaguar.stud.ntnu.no

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mirzaei@stud.ntnu.no
  Subject: Re: User defined types
  In-Reply-To: <Pine.LNX.4.58.0411201729220.32082@jaguar.stud.ntnu.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox