dbTalk Databases Forums  

[BUGS] %ROWTYPE in RETURNS clause of CREATE FUNCTION statement causes a parser error. Postges 7.4 & 7.4.1

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


Discuss [BUGS] %ROWTYPE in RETURNS clause of CREATE FUNCTION statement causes a parser error. Postges 7.4 & 7.4.1 in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ezra epstein
 
Posts: n/a

Default [BUGS] %ROWTYPE in RETURNS clause of CREATE FUNCTION statement causes a parser error. Postges 7.4 & 7.4.1 - 12-24-2003 , 06:57 PM






Running under cygwin on Windows 2000 and Windows XP.

It appears that %ROWTYPE is not allowed in the RETURNs clause of function
declarations. It could be that this is a "feature" but it seems an odd one
since %ROWTYPE is allowed in the parameter list and DECLARE section of
PL/pgSQL functions.

== Ezra Epstein



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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.