From: Patrice OLIVER <oliverp21@free.fr>
To: pgsql-sql@postgresql.org
Subject: stored procedures and type of returned result.
Date: Tue, 24 Aug 2004 10:39:24 +0200
Message-ID: <412AFEBC.4060404@free.fr> (raw)
***********************
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oliverp21@free.fr
Subject: Re: stored procedures and type of returned result.
In-Reply-To: <412AFEBC.4060404@free.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox