X-Original-To: pgsql-general-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id A506B9FB36A;
	Tue,  1 Aug 2006 19:37:42 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 55224-02; Tue,  1 Aug 2006 19:37:33 -0300 (ADT)
X-Greylist: delayed 01:00:04.67029 by SQLgrey-
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from rome.boulder.noaa.gov (rome.boulder.noaa.gov [140.172.10.146])
	by postgresql.org (Postfix) with ESMTP id E5D699FA432;
	Tue,  1 Aug 2006 19:37:32 -0300 (ADT)
Received: from [137.75.70.84] (dwezil.fsl.noaa.gov [137.75.70.84])
	by email.boulder.noaa.gov
	(iPlanet Messaging Server 5.2 HotFix 2.01 (built Aug 26 2004))
	with ESMTPSA id <0J3C00MG29EC5G@email.boulder.noaa.gov>; Tue,
	01 Aug 2006 21:37:24 +0000 (GMT)
Date: Tue, 01 Aug 2006 21:37:23 +0000
From: Christopher Steffen <Christopher.Steffen@noaa.gov>
Subject: Re: Help with plpgsql - subst variable value
To: bodnar@malva.com.ua
Cc: pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org
Message-id: <44CFC993.4060309@noaa.gov>
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
X-Accept-Language: en-us, en
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.13) Gecko/20060414
	Red Hat/1.7.13-1.1.3.1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200608/94
X-Sequence-Number: 98866

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

Thanks,
Chris Steffen