The following bug has been logged online:

Bug reference: 1966
Logged by: Tony Caduto
Email address: tony_caduto@amsoftwaredesign.com
PostgreSQL version: 8.1
Operating system: Linux
Description: Single OUT PARM does not return param name.
Details:

When creating a plpgsql function that has one OUT param the function returns
the name of the function as the column name instead of the OUT param name.
This behavior is not consistant with the behavior of other DB systems and
needs to be fixed so that if a single OUT param is specifed the name of the
param is returned.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Tony Caduto wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1966
> Logged by: Tony Caduto
> Email address: tony_caduto@amsoftwaredesign.com
> PostgreSQL version: 8.1
> Operating system: Linux
> Description: Single OUT PARM does not return param name.
> Details:
>
> When creating a plpgsql function that has one OUT param the function returns
> the name of the function as the column name instead of the OUT param name.
> This behavior is not consistant with the behavior of other DB systems and
> needs to be fixed so that if a single OUT param is specifed the name of the
> param is returned.

This will be fixed in 8.1beta3. Thanks for the report.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match