create function .... return record

Поиск
Список
Период
Сортировка
От Chris Mulcahy
Тема create function .... return record
Дата
Msg-id 000e01c11223$ab899380$0301a8c0@cmulcahy.com
обсуждение исходный текст
Ответ на Re: Postgres User and Password  (R Talbot <os2unix@attglobal.net>)
Список 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)



В списке pgsql-general по дате отправления:

Предыдущее
От: Jeremy Hansen
Дата:
Сообщение: foreign keys?
Следующее
От: "Mitch Vincent"
Дата:
Сообщение: Re: How Postgresql Compares For Query And Load Operations