Re: procedure properties problem

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Rikard Pavelic" <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: procedure properties problem
Date: 2006-01-17 12:55:08
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40103D877@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Rikard Pavelic [mailto:rikard(dot)pavelic(at)zg(dot)htnet(dot)hr]
> Sent: 17 January 2006 10:40
> To: Dave Page
> Cc: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] procedure properties problem
>
> If I omit the 'returns setof varchar' I will get only one
> result from select
> If I add 'returns setof varchar' I will get two results.

Ahh, yes, I see what you mean. Well, pgAdmin actually doesn't seem to
support set returning procedures at all. I've committed changes to trunk
and the stable branch to properly display the defintion of such objects,
and further changes to trunk to allow yoou to create them through the
GUI as well.

Thanks for the example.

Regards, Dave.

Browse pgadmin-support by date

  From Date Subject
Next Message Hogan, James F. Jr. 2006-01-17 15:43:16 Re: pgagent jobs never start
Previous Message Rikard Pavelic 2006-01-17 10:40:08 Re: procedure properties problem