> -Original Message-
> From: Rikard Pavelic [mailto:[EMAIL PROTECTED]
> Sent: 17 January 2006 10:40
> To: Dave Page
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] procedure properties problem
>
> If I omit the 'returns setof
Dave Page wrote:
The function written above will never work as you have a mismatch of
parameter and return types, but in answer to your query, the PostgreSQL
docs say:
"When there are OUT or INOUT parameters, the RETURNS clause may be
omitted."
(http://www.postgresql.org/docs/8.1/interactive/sq
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Rikard Pavelic
> Sent: 16 January 2006 15:02
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] procedure properties problem
>
> Hi!
> I don't
Hi!
I don't know if this is missing feature or bug, but just to report this.
If I create functions like
create or replace function example(out data varchar) returns setof record as
$$
select data from table
$$ language sql;
pgAdmin displays it without 'returns setof record'.
---
