On Fri, 11 Jan 2008, P Kishor wrote:
it to PostGres (pain in the tush to develop with, but great to serve
The actual name is PostgreSQL and it's usually referred to as postgres.
For example, why have the "INTEGER PRIMARY KEY" when it could just as
easily be called "SERIAL"?
One way might be to allow for aliases -- so, SERIAL would mean the
same as INTEGER PRIMARY KEY, or CHAR(3) would mean the same as TEXT
with a CHECK CONSTRAINT, and so on.
From the PostgreSQL 8.1 docs:
The data types serial and bigserial are not true types, but merely a
notational convenience for setting up unique identifier columns (similar to
the AUTO_INCREMENT property supported by some other databases). In the
current implementation, specifying
CREATE TABLE tablename (
colname SERIAL
);
is equivalent to specifying:
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename (
colname integer DEFAULT nextval('tablename_colname_seq') NOT NULL
);
You can create your own.
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
