Stored procedure

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Stored procedure
Date: 2007-03-13 17:29:36
Message-ID: 75645bbb0703131029y52bcc6c3s86341ae9cf38a32d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a stored procedure which returns a SETOF RECORD.
so basically a partial rowtype from a table.

to execute the query in PHP, i must write :
select * from myschema.sp_a_002('username') as result(Column1 varchar);

to get the result.

However, is there another to get the result without using 'as result(column1
varchar)' ?
something like a simple "select * from storedprocedure(param);", for example
:-)

thanks a lot,

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Legault 2007-03-13 17:57:39 Re: Stored procedure
Previous Message Thomas F. O'Connell 2007-03-13 17:11:56 Re: New US DST Rules & PostgreSQL