Developer's Frequently Asked Questions (FAQ) for PostgreSQL

Last updated:Mon Oct4 11:29:26 EDT 2004

Last updated:Thu Oct14 15:00:26 EDT 2004

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)

There are two pertinent standards, SQL92 and SQL99. These standards

are endorsed by ANSI and ISO. A draft of the SQL92 standard is

available at http://www.contrib.andrew.cmu.edu/~shadow/. The SQL99

for SQL99. The SQL 2003standards are at

available at

-2-1999.pdf. The SQL 2003standard is at

http://www.wiscorp.com/sql/sql_2003_standard.zip

A summary of these standards is at

http://dbs.uni-leipzig.de/en/lokal/standards.pdf.

Some SQL standards web pages are:

* http://www.wiscorp.com/SQLStandards.html

* http://troels.arvin.dk/db/rdbms/links/#standards

* http://dbs.uni-leipzig.de/en/lokal/standards.pdf (paper)

Technical Questions

2.1) How do I efficiently access information in tables from the backend code?

<H1>Developer's Frequently Asked Questions (FAQ) for

PostgreSQL</H1>

<P>Last updated:Mon Oct 4 11:29:26 EDT 2004</P>

<P>Last updated:Thu Oct14 15:00:26 EDT 2004</P>

<P>Current maintainer: Bruce Momjian (<Ahref=

"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>

<P>There are two pertinent standards, SQL92 and SQL99. These

standards are endorsed by ANSI and ISO. A draft of the SQL92

standard is available at<a

href="http://www.contrib.andrew.cmu.edu/~shadow/">

http://www.contrib.andrew.cmu.edu/~shadow/</a>. The SQL99 standard

must be purchased from ANSI at<a

href="http://webstore.ansi.org/ansidocstore/default.asp">

http://webstore.ansi.org/ansidocstore/default.asp</a>. The main

standards documents are ANSI X3.135-1992 for SQL92 and ANSI/ISO/IEC

9075-2-1999 for SQL99. The SQL 2003 standards are at<ahref=

http://www.contrib.andrew.cmu.edu/~shadow/sql.html#syntax">

http://www.contrib.andrew.cmu.edu/~shadow/sql.html#syntax</a>. A

draft of the SQL99 standard is at<a

href="http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/SQL1999/ansi-iso-9075-2-1999.pdf">

http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/SQL1999/ansi-iso-9075-2-1999.pdf</a>.

The SQL 2003 standard is at<ahref=

"http://www.wiscorp.com/sql/sql_2003_standard.zip">

http://www.wiscorp.com/sql/sql_2003_standard.zip</A></P>

<P>A summary of these standards is at<a

<P>Some SQL standards web pages are:

href="http://www.wiscorp.com/SQLStandards.html">

http://www.wiscorp.com/SQLStandards.html</a></li>

href="http://troels.arvin.dk/db/rdbms/links/#standards">

http://troels.arvin.dk/db/rdbms/links/#standards</a></li>

href="http://dbs.uni-leipzig.de/en/lokal/standards.pdf">

http://dbs.uni-leipzig.de/en/lokal/standards.pdf</a>.</P>

http://dbs.uni-leipzig.de/en/lokal/standards.pdf</a> (paper)</li>

<H2>Technical Questions</H2>