Re: creating names in plpgsql-functions

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
>