Hi,
Thankx guys I am now able to increment that field by using serial.
Richard Huxton wrote:
>
> Yesh wrote:
>> Hi,
>>
>> I need to know how to increment a primary key field automatically in
>> run
>> time.
>
> Not sure precisely what you want to know, but read up on the SERIAL
> type, se
On mán, 2007-01-01 at 21:21 -0800, Yesh wrote:
> I need to know how to increment a primary key field automatically in run
> time.
Will SERIAL do what you want?
gnari
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
Yesh wrote:
Hi,
I need to know how to increment a primary key field automatically in run
time.
If you use the "serial" data type, the database does this for you
automatically and you don't have to worry about it.
Is this the data type your using?
--
James Neff
Technology Specialist
T
On 1 Jan 2007 at 21:21, Yesh wrote:
> I need to know how to increment a primary key field automatically in
> run time.
Use type SERIAL as your primary key - here is the relevant page in
the docs:
http://www.postgresql.org/docs/8.2/static/datatype-
numeric.html#DATATYPE-SERIAL
HTH,
--Ray.
-
Yesh wrote:
Hi,
I need to know how to increment a primary key field automatically in run
time.
Not sure precisely what you want to know, but read up on the SERIAL
type, sequences, nextval() and currval().
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
Hi,
I need to know how to increment a primary key field automatically in run
time.
--
View this message in context:
http://www.nabble.com/About-auto_increment-tf2906530.html#a8120183
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of b
