pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Automatic index numbers
2+ messages / 2 participants
[nested] [flat]

* Automatic index numbers
@ 2000-05-18 00:52  Daniel Mendyke <daniel@clacknet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Daniel Mendyke @ 2000-05-18 00:52 UTC (permalink / raw)
  To: pgsql-sql


How can I automatically create a unique index
number when I add new data to a table?

Does this have to be done through a high level
language or does the database provide a function
for this?

-Daniel

--

To reach me remove the 'nospam.' from my address.
I can be reached at 'daniel at clacknet dot com'








^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Automatic index numbers
@ 2000-05-24 19:38  Kees Kuip <keeskuip@technologist.com>
  parent: Daniel Mendyke <daniel@clacknet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Kees Kuip @ 2000-05-24 19:38 UTC (permalink / raw)
  To: pgsql-sql

Daniel Mendyke wrote:
> 
> How can I automatically create a unique index
> number when I add new data to a table?
> 

Try 

CREATE TABLE test
(
   id serial
)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-05-24 19:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-18 00:52 Automatic index numbers Daniel Mendyke <daniel@clacknet.com>
2000-05-24 19:38 ` Kees Kuip <keeskuip@technologist.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox