Serial Data Type?

Serial Data Type?

Post by Lisa Grigla » Fri, 08 Apr 1994 22:14:24



I understand Ingres has something called a serial data type that I might be able to
use.  We are still using Ingres V5.0-06 (groan) and I don't see anything about a
serial data type in any of the manuals I have.  Is this data type something that
was added after V5.0?

--
Lisa Griglack
Hughes Network Systems, Inc.
(301) 601-7211

 
 
 

Serial Data Type?

Post by Roy Ha » Sat, 09 Apr 1994 05:55:55


: I understand Ingres has something called a serial data type that I might be able to
: use.  We are still using Ingres V5.0-06 (groan) and I don't see anything about a
: serial data type in any of the manuals I have.  Is this data type something that
: was added after V5.0?

Whatever the source of your information is, I am afraid it is just
dead wrong.  This has been the subject of a moderately long thread
on this group in the last month.  No, INGRES does NOT have a serial
datatype.  Possibly your source was talking about the logical key
data types.  These are (IMO) of limited usefulness, but there are
people on this group who insist that they are good and useful so you
should check them out to see if yours is one of the kinds of problems
they address.

Yes, the logical key type appeared in Release 6.

========================================================================


BKB Engineering Ltd.,                      (MIME-capable mail agent)
11211-76th Avenue,                
Edmonton, Alberta                          Tel: (403)438-2531 (office)
T6G 0K2                                         (403)437-0860 (home)
Canada                                     FAX: (403)437-3367

========================================================================

 
 
 

1. serial data type

Some database engines like INFORMIX offer a serial data type. Can I build
this datatype with SQL-Server 6.5?

The behaviour is as follows:

1) insert into tb_table (c_serial, c_char) values (111, "test")
-> inserts 111 in c_serial and "test" in c_char

2) insert into tb_table(c_serial, c_char) values (0, "test")
-> insert 112 in c_serial and "test" in c_char

3) insert into tb_table(c_char) values("test")
-> inserts 113 in c_serial and "test" in c_char

Statement 2 + 3 insert the next available number in c_serial.

2. How can I get the position(#_of_line) od the cursor(not the mouse) ?????

3. MO-KANSAS CITY-38202--ORACLE-DBA Skills-Customer Support-Oracle DBAs

4. Serial data type not starting at 1

5. Shared Memory Setup - Info Required

6. COPY INTO and the SERIAL data type

7. Field Name Performance

8. Serial Data Type in Informix

9. Informix serial data types in Delphi

10. serial data type

11. SERIAL data type

12. Informix SERIAL data type question