Re: when I create a table, postgresql creates a new type - Mailing list pgsql-general

From scott.marlowe
Subject Re: when I create a table, postgresql creates a new type
Date
Msg-id Pine.LNX.4.33.0401191125170.11187-100000@css120.ihs.com
Whole thread Raw
In response to when I create a table, postgresql creates a new type  ("Julio Misael Gutierrez" <jmisaelg@amnetsal.com>)
List pgsql-general
On Thu, 15 Jan 2004, Julio Misael Gutierrez wrote:

> Good day,
> I´m testing PostGresql,
> I would like to Know why when I create a new table,
> postgresql create a new type with the same name of the table.
> Where I can find more information about this?.

To add to what Tom said, this allows you to create functions that return a
set of 'newtable_type'  where newtable_type is the newtable you've
created.  I.e. you can have a function return rows just like the table you
created.  nifty, huh?


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Postgress and MYSQL
Next
From: Steve Atkins
Date:
Subject: Re: Postgress and MYSQL