selecting a attribute from a function

From: "A(dot)j(dot) Langereis" <a(dot)j(dot)langereis(at)inter(dot)nl(dot)net>
To: "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: selecting a attribute from a function
Date: 2005-11-24 10:47:53
Message-ID: 006201c5f0ee$affe52d0$3e01a8c0@aarjan2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

I have written a function that returns a set. This set is of a type I made, containing multiple attributes.

create type my_type as (col1 int, col2 int)

Something likes this works:

select col1 from my_pg_func('hello');

But how can I do something like this:

select my_pg_func(table2.some_col).col1
from table2.some_col

Yours,

Aarjan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Presber 2005-11-24 11:20:04 Errors with temporary tables
Previous Message Ledina Hido 2005-11-24 09:24:46 Re: Delete statement does not work with PostgreSQL 8.0.1