Hi,
thanks for the responses to my original question. i have decided to use
phpPgAdmin for my database development.
I have created the following function:
create function GetEmployees() returns setof employee as 'select * from
employee;' language 'sql';
With phpPgAdmin you can define the top and bottom lines of your
function using the options available (Name, Arguments,
Returns,Programming language). Now the section that is throwing me at
the moment is the reyurns section. You have 2 drop down boxes, the
first enables you to select setof and the second provides you with a
long list. So basically I chosse a name for the function, provide
'text' as an argument to my function, select setof from the first drop
down box and plpgsql as my programming language. how do I set the
'employe part of the function from the drop down list? 'returns setof
xxxx, xxxx being the option i need to select from the drop down list
which is defaulted to "SET".
regards
Uzo
On 31 Dec 2003, at 19:57, Andy Lewis wrote:
> I would have to agree with EMS-HiTech's product also. A feature rich,
> product, very responsive tech support/bug report. PGManager beats the
> competition hands down.
>
> Andy
>
>
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Rich Hall
> Sent: Wednesday, December 31, 2003 1:09 PM
> To: pgsql-sql@postgresql.org
> Subject: Re: [SQL] postgreSQL editors
>
>
>
>>> can anyone recommend a good editor for postgreSQl wich wil enable me
>>> to create functions/stored procedures?
>>> I am currently running version 7.4.1 on OS X 10.3
>>
>
> I use PG Manager from EMS Hitech. It is not free but inexpensive.
>
> You have everything PostgreSQL-wise at your fingertips.
>
> Ver 2.0 was just released and they are very responsive to bug reports.
>
> Rick
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>