dbTalk Databases Forums  

[BUGS] BUG #1966: Single OUT PARM does not return param name.

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1966: Single OUT PARM does not return param name. in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony Caduto
 
Posts: n/a

Default [BUGS] BUG #1966: Single OUT PARM does not return param name. - 10-14-2005 , 07:46 AM







The following bug has been logged online:

Bug reference: 1966
Logged by: Tony Caduto
Email address: tony_caduto (AT) amsoftwaredesign (DOT) 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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
  #2  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: [BUGS] BUG #1966: Single OUT PARM does not return param name. - 10-14-2005 , 07:59 AM






Tony Caduto wrote:
Quote:
The following bug has been logged online:

Bug reference: 1966
Logged by: Tony Caduto
Email address: tony_caduto (AT) amsoftwaredesign (DOT) 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 (AT) candle (DOT) 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.