Re: creating names in plpgsql-functions - Mailing list pgsql-general

From Stephan Szabo
Subject Re: creating names in plpgsql-functions
Date
Msg-id Pine.BSF.4.21.0104282209210.33889-100000@megazone23.bigpanda.com
Whole thread Raw
In response to creating names in plpgsql-functions  (Lieven Van Acker <lieven@elisa.be>)
List pgsql-general
Under 7.0.x and earlier, no.
Under 7.1, you can use execute to execute a string which
could have dynamic bits (replace create sequence seqname;
with execute ''create sequence '' || seqname;)


On Sat, 28 Apr 2001, Lieven Van Acker wrote:

> Hi,
>
> is there a way to make a name in a plpgsql procedure dynamic? I want to
> do something like this:
>
> CREATE FUNCTION create_admin(BPCHAR)
> RETURNS BPCHAR AS '
>         DECLARE
>                 seqname name;
>                 a alias for $1;
>         BEGIN
>                 insert into admin(adminid)
>                 values (a);
>
>                 seqname := a || ''_seq'';
>
>                 create sequence seqname;
>
>                 return seqname;
>         END;'
> LANGUAGE 'plpgsql';
>
> Calling this function returns
>
> SELECT create_admin('TS');
> ERROR:  parser: parse error at or near "$1"
>
> Thanks,
>
> Lieven
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Re: On the _need_ to vacuum...
Next
From: Alfred Perlstein
Date:
Subject: Re: Re: On the _need_ to vacuum...