Skip site navigation (1) Skip section navigation (2)

stored procedures and type of returned result.

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: (view raw, whole thread or download thread mbox)
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.


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 ?

Patrice OLIVER.


pgsql-sql by date

Next:From: Richard HuxtonDate: 2004-08-24 09:26:12
Subject: Re: stored procedures and type of returned result.
Previous:From: Philippe LangDate: 2004-08-24 07:41:58
Subject: Disable trigger with Postgresql 7.4.x?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group