From: | Patrice OLIVER <oliverp21(at)free(dot)fr> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | stored procedures and type of returned result. |
Date: | 2004-08-24 08:39:24 |
Message-ID: | 412AFEBC.4060404@free.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-08-24 09:26:12 | Re: stored procedures and type of returned result. |
Previous Message | Philippe Lang | 2004-08-24 07:41:58 | Disable trigger with Postgresql 7.4.x? |