Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
*Alexander Bodnar
*
Try
ObjectSeqName TEXT :=  foobar;
EXECUTE 'CREATE SEQUENCE ' || ObjectSeqName || ' start 1 increment 1 
maxvalue 2147483647';

Thanks,
Chris Steffen

pgsql-interfaces by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group