Re: how to create a composite type as return type for a

On Thu, 9 Dec 2004, Tjibbe Rijpma wrote:

> I want to make a Function as table source. As rettype you have to give a
> composite type but how do I make those? I'm using an new empty table with
> the the datatypes (INT, INT8, TEXT and a TIMESTAMP) I need.
>
> Is this the normal way how to make composite types?
>
> Example:
>
> CREATE TABLE bigint_int_text_timestamp (
> column_1 INT8,
> column_2 INT,
> column_3 TEXT,
> column_4 TIMESTAMP);

I'd normally use CREATE TYPE AS.

CREATE TYPE bigint_int_text_timestamp AS (
column_1 int8,
column_2 int,
column_3 text,
column_4 timestamp);