create function .... return record

From: "Chris Mulcahy" <cmulcahy(at)cmulcahy(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: create function .... return record
Date: 2001-07-21 20:28:14
Message-ID: 000e01c11223$ab899380$0301a8c0@cmulcahy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings:

I am attempting to create a function that returns a record. I have two
problems, one is that Postgresql does not recognize the return type
record. How do I set this up?

The second issue I'm having is that I've found plenty of examples to do
a 'select into recReturn * from theTable' but I want to have two select
statements stuffing info into my record.

Maybe I'm not even coming up with the right solution. I'm trying to
create a function that returns two or more values. What is the best way
to do that?

Thanks
Chris (relativly new to PgSQL, but not new to SQL)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2001-07-21 20:38:10 Re: How Postgresql Compares For Query And Load Operations
Previous Message Jeremy Hansen 2001-07-21 20:15:24 foreign keys?