head	1.1;
access;
symbols
	PG95_1_01:1.1;
locks; strict;
comment	@# @;


1.1
date	96.02.24.01.16.23;	author jolly;	state Exp;
branches;
next	;


desc
@@


1.1
log
@SQL-ized Reference Manual (ported from postgres v4r2)
Thanks to Andrew (and Claire and Dorothy)
@
text
@.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
.\" $Header: /usr/local/devel/postgres/src/ref/RCS/introduction,v 1.25 1994/06/30 09:10:17 aoki Exp $
.TH "INTRODUCTION" "POSTGRES95" "11/5/95"
.\" XXX this .XA must come after .TH initializes the macro package (like
.\"	the page number...)
.XA 0 "Section 1 \(em Introduction"
.BH "SECTION 1 \(em INTRODUCTION"
.SH "OVERVIEW"
This document is the reference manual for the \*(PG database
management system under development at the University of California at
Berkeley.  The \*(PG project, led by Professor Michael Stonebraker, 
has been sponsored by the Defense Advanced Research Projects Agency (\c
.SM DARPA\c
),
the Army Research Office (\c
.SM ARO\c
),
the National Science Foundation (\c
.SM NSF\c
),
and
.SM Digital Equipment Corporation\c
.
.PP
This reference manual describes Version \*(PV of \*(PG.  
It assumes proficiency in C, C++, and SQL programming.
\*(PG is copyrighted by the Regents of the
University of California. However, the source code is freely
modifiable and distributable.
Information on obtaining \*(PG source
code is available from the \*(PG home page at the following URL:
.sp
.(l
http://s2k-ftp.cs.berkeley.edu:8000/postgres95
.)l
.sp
\*(PG is based on the last official release
of POSTGRES, Version 4.2 and provides enhanced performance
and managibility.
The code has been trimmed by 25% and runs 30-50%
faster than POSTGRES v.4.2 on the Wisconsin Benchmark.
More significantly \*(PG 
no longer uses POSTQUEL query language but rather
employs standard query language, SQL. 
For a more detailed description of specific 
changes to the code please consult the \*(PG
User's Manual. 
.PP
\*(PG has been complied and tested on
.TS
allbox center;
c c c
l l l.
Architecture	Processor	Operating System
=
Intel x86	Pentium	Linux 1.3.42
DECstation 3000	Alpha AXP	OSF/2.0, 3.0
DECstation 5000	MIPS	ULTRIX 4.4
Sun4	SPARC	SunOS 4.1.3, 4.1.3_UI, Solaris 2.4
HP 9000/700 & 800	PA-RISC	HP-UX 9.00, 9.01, 9.03
.TE
.PP
Application developers should note
that this manual contains only the specification for the low-level
call-oriented application program interface, \*(LI.  A companion
volume, the \*(PG User's Manual, contains tutorial examples of the ways
in which the system can be extended.
.PP
The remainder of this reference manual is structured as follows.
Section 2 (UNIX), discusses the \*(PG capabilities that are available
directly from the operating system.  Section 3 (BUILT-INS) describes
\*(PG internal data types, functions, and operators.  Section 4
(COMMANDS) describes \*(PQ, the language by which a user
interacts with a \*(PG database.  Then, Section 5 (LIBPQ) describes a
library of low level routines through which a user can formulate \*(PQ
queries from a C program and get appropriate return information back
to his program.  Section 6 (LARGE OBJECTS) describes
the internal \*(PG interface for accessing large objects.  Section 7
(SYSTEM CATALOGS) gives a brief explanation of the tables used
internally by \*(PG.  The reference concludes with Section 8 (FILES),
a collection of file format descriptions for files used by \*(PG.
.SH "ACKNOWLEDGEMENTS"
The primary authors of \*(PG are Jolly Chen and Andrew Yu. Previous
versions of POSTGRES was constructed by a team of undergraduate, graduate, and
staff programmers:
Jeff Anton,
Paul Aoki,
James Bell,
Jennifer Caetta,
Philip Chang,
Jolly Chen,
Ron Choi,
Matt Dillon,
Zelaine Fong,
Adam Glass,
Jeffrey Goh,
Steven Grady,
Serge Granik,
Marti Hearst,
Joey Hellerstein,
Michael Hirohama,
Chin-heng Hong,
Wei Hong,
Anant Jhingran,
Greg Kemnitz,
Marcel Kornacker,
Case Larsen,
Boris Livshitz,
Jeff Meredith,
Ginger Ogle,
Michael Olson,
Nels Olson,
Lay-Peng Ong,
Carol Paxson,
Avi Pfeffer,
Spyros Potamianos,
Sunita Sarawagi,
David Muir Sharnoff,
Mark Sullivan,
Cimarron Taylor,
Marc Teitelbaum,
Yongdong Wang,
Kristin Wright
and
Andrew Yu.
.PP
This reference was collectively written by the above implementation
team, assisted by 
Claire Mosher
and
Dorothy Moore.
.SH "LEGAL NOTICES"
\*(PG is copyrighted
by the
Regents of the University of California.
.PP
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written agreement
is hereby granted, provided that the above copyright notice, this
paragraph, and the following two paragraphs appear in all copies.
.PP
IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR
DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGE.
.PP
THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER IS
ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO
PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
.PP
\*(UU is a trademark of X/Open, Ltd.  Sun4, SPARC, SunOS and Solaris
are trademarks of Sun Microsystems, Inc.  DEC, DECstation, Alpha AXP
and ULTRIX are trademarks of Digital Equipment Corp.  PA-RISC and
HP-UX are trademarks of Hewlett-Packard Co.  RS/6000, POWER and AIX
are trademarks of International Business Machines Corp.  OSF/1 is a
trademark of the Open Systems Foundation.  NeXTSTEP is a trademark of
NeXT Computer, Inc.  MIPS and IRIX are trademarks of Silicon Graphics,
Inc.
@
