Re: Help with plpgsql - subst variable value

From: Christopher Steffen <Christopher(dot)Steffen(at)noaa(dot)gov>
To: bodnar(at)malva(dot)com(dot)ua
Cc: pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Help with plpgsql - subst variable value
Date: 2006-08-01 21:37:23
Message-ID: 44CFC993.4060309@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

*Alexander Bodnar
*
Try
ObjectSeqName TEXT := foobar;
EXECUTE 'CREATE SEQUENCE ' || ObjectSeqName || ' start 1 increment 1
maxvalue 2147483647';

Thanks,
Chris Steffen

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2006-08-01 22:37:35 Re: money type depreciated?
Previous Message Eric Andrews 2006-08-01 21:01:32 Re: proper use of array datatype

Browse pgsql-interfaces by date

  From Date Subject
Next Message gouse shaik 2006-08-02 06:07:45 PGconn structure
Previous Message Joachim Wieland 2006-08-01 07:39:48 Re: Using FETCH ALL with descriptor areas