Message-ID: <412AFEBC.4060404@free.fr>
Date: Tue, 24 Aug 2004 10:39:24 +0200
From: Patrice OLIVER <oliverp21@free.fr>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: stored procedures and type of returned result.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

***********************
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.