Returning with a userd defined type (PL/pgSQL)

From: Együd Csaba <csegyud(at)freemail(dot)hu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Returning with a userd defined type (PL/pgSQL)
Date: 2003-04-25 05:27:15
Message-ID: 000f01c30aeb$8393f510$200a0a0a@notebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I would like to return a set with a self-defined type.
Actually this type contains a subset of a physical table's columns and some
other columns.
It should hold rows which are filled in with the table data on the one hand
and the additionally calculated data on the other hand.

I can do it when I want to return a set provided by a query (using return
next;), but how can I extend this structure with additional information?

Thank you in advance.

Best Regards
Csaba

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-04-25 05:52:04 Re: Solaris
Previous Message Robert Treat 2003-04-25 04:03:24 Re: [SQL] rewriting values with before trigger