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(at)Yahoo(dot)com #

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