stored procedures and type of returned result.

Поиск
Список
Период
Сортировка
От Patrice OLIVER
Тема stored procedures and type of returned result.
Дата
Msg-id 412AFEBC.4060404@free.fr
обсуждение исходный текст
Ответы Re: stored procedures and type of returned result.  (Richard Huxton <dev@archonet.com>)
Список pgsql-sql
***********************
Aucun virus n'a été détecté dans la pièce-jointe no filename
---
No virus was detected in the attachment no filename

Votre courrier a été inspecté par InterScan Messaging Security Suite
---
Your mail has been scanned by InterScan MSS.
***********************


Hello,

I'm new in PostgreSQL. It's very cool.

I would like to know how to return a set of records from a stored procedure.

For example, i would like to execute these sql command from a stored 
procedure :

select t.typnum, t.typcom, t.typcateg, s.symurlgraph from structure.type t  left join structure.symbole s  on t.typcode
=s.typcode;
 

Is it possible ?
Do i have to return results in an array ?
If yes, how could i do ?

Do you think using plPHP mays help me ?

Regards,
Patrice OLIVER.




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

Предыдущее
От: "Philippe Lang"
Дата:
Сообщение: Disable trigger with Postgresql 7.4.x?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: stored procedures and type of returned result.