Re: Re: PLpgSQL

Josh Berkus wrote:
> Dado,
> 
> > But still, the $1 is still plaguing me.
> > 
> 
> Here's your problem:
> 
> > >>CREATE FUNCTION new_proj_pts_seq(int4)
> > >>RETURNS text
> > >>AS 'DECLARE
> > >>        proj_ID alias for $1;
> > >>        seq_name TEXT;
> > >>    BEGIN
> > >>        seq_name := ''proj_pts_'' || proj_ID;
> > >>        create sequence seq_name;
> > >>    END;
> > >>    RETURNS seq_name;'
> 
> This should read: RETURN seq_name
> 
> No "S".
   And should be placed before the END;

> 
> > >>LANGUAGE 'plpgsql';
> 
> -Josh

Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com