Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!aramis.rutgers.edu!paul.rutgers.edu!yes.rutgers.edu!emuleomo
From: emuleomo@yes.rutgers.edu (Emuleomo)
Newsgroups: comp.databases
Subject: Re: Attn: RTIngres GURUs
Message-ID: <Jun.23.12.01.07.1989.1388@yes.rutgers.edu>
Date: 23 Jun 89 16:01:12 GMT
References: <449@sdcc15.ucsd.edu> <2981@rtech.rtech.com> <Jun.16.10.45.37.1989.7766@yes.rutgers.edu> <3003@rtech.rtech.com>
Organization: Rutgers Univ., New Brunswick, N.J.
Lines: 21


Just as a quick followup on my previous question <again for RTI gurus>

IS THERE A WAY TO IMPLEMENT a SERIAL fld in Ingres (as is done in Informix)??

A serial fld is a fld which has ALL the following properties.
(AS defined by Informix software)
a)  It uniquely identifies a row in a table. i.e. it is a key for that row.
b)  It is managed by the DBMS AUTOMATICALLY and a unique value is
    generated for any new row inserted into that table.
c)  It cannot be modified, once generated!

** I dont understand why I (a self proclaimed Informix Guru) am having _such_
a hard time with Ingres.  Maybe I should stop thinking in Informix!
However, I thought that SQL is SQL is SQL! and RDBMS is RDBMS is RDBMS.

Respondez S'Il vouz plait.

--Emuleomo O.O. (emuleomo@yes.rutgers.edu)
-- 
** Research is what I'm doing when I dont know what I'm doing! **