From epalo@ono.com Mon Feb  10 23:55:20 2003
X-Original-To: pgsql-docs@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 758D5475A5C; Mon, 10 Feb 2003 18:55:20 -0500 (EST)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP
	id 0ED72475A4B; Mon, 10 Feb 2003 18:55:20 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id EB6C443A911; Mon, 10 Feb 2003 18:55:19 -0500 (EST)
From: "Eduardo" <epalo@ono.com>
X-Newsgroups: comp.databases.postgresql.docs,
 comp.databases.postgresql.general,
	comp.databases.postgresql.sql
Subject: PL/PGSQL TUTORIAL
Date: Tue, 11 Feb 2003 00:53:13 +0100
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 7
Message-ID: <b29e57$20q5$1@news.hub.org>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
To: pgsql-docs@postgresql.org, pgsql-general@postgresql.org,
	pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/8
X-Sequence-Number: 1642

Where can i find a tutorial of PL/PGSQL?
Where is the complete oficial reference?
And where is the oficial web with the standars of SQL?

Thanks.





From middink@indo.net.id Sat Oct  11 07:47:52 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 220FAD1B505
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 07:47:52 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 03718-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 04:47:08 -0300 (ADT)
Received: from smtp-1.indo.net.id (smtp-1.indo.net.id [202.159.32.91])
	by svr1.postgresql.org (Postfix) with SMTP id B6303D1B4F0
	for <pgsql-sql@postgresql.org>; Sat, 11 Oct 2003 04:46:58 -0300 (ADT)
Received: (qmail 31300 invoked from network); 11 Oct 2003 14:46:52 +0700
Received: from smtp.indo.net.id (202.159.32.81)
	by smtp-1.indo.net.id with SMTP; 11 Oct 2003 14:46:52 +0700
Received: (qmail 1717 invoked from network); 11 Oct 2003 07:44:30 -0000
Received: from unknown (HELO pop.makassar.indo.net.id) (202.159.23.19)
	by smtp.indo.net.id with SMTP; 11 Oct 2003 07:44:30 -0000
Received: FROM middinkcomp BY pop.makassar.indo.net.id ;
	Sat Oct 11 15:55:38 2003 +0700
Message-ID: <002901c38fcd$5e4d0780$1f00a8c0@middinkcomp>
From: "Muhyiddin A.M Hayat" <middink@indo.net.id>
To: <pgsql-sql@postgresql.org>
Subject: PL/PGSQL TUTORIAL
Date: Sat, 11 Oct 2003 15:57:47 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0026_01C39010.6A5F1AC0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=HTML_40_50,
	SUBJ_ALL_CAPS
X-Spam-Level: *
X-Archive-Number: 200310/114
X-Sequence-Number: 15514

This is a multi-part message in MIME format.

------=_NextPart_000_0026_01C39010.6A5F1AC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Where can i find a complete full terminated database schema in SQL?

I want to see a real complete database schema with views, triggers.. etc,...

------=_NextPart_000_0026_01C39010.6A5F1AC0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>Where can i find a complete full terminated databas=
e=20
schema in SQL?<BR><BR>I want to see a real complete database schema with vi=
ews,=20
triggers.. etc,...
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0026_01C39010.6A5F1AC0--





From dev@archonet.com Sat Oct  11 09:32:45 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 82969D1B519
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 09:32:45 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 31368-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 06:32:02 -0300 (ADT)
Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net
	[194.217.242.88])
	by svr1.postgresql.org (Postfix) with ESMTP id A98C3D1B50E
	for <pgsql-sql@postgresql.org>; Sat, 11 Oct 2003 06:31:55 -0300 (ADT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-30.mail.demon.net with esmtp (Exim 3.35 #1)
	id 1A8G6U-0008mn-0U; Sat, 11 Oct 2003 10:32:02 +0100
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 2D1F2178E3; Sat, 11 Oct 2003 10:32:01 +0100 (BST)
Received: from client17.archonet.com (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 82FC2178E2; Sat, 11 Oct 2003 10:32:00 +0100 (BST)
From: Richard Huxton <dev@archonet.com>
To: "Muhyiddin A.M Hayat" <middink@indo.net.id>,
	<pgsql-sql@postgresql.org>
Subject: Re: PL/PGSQL TUTORIAL
Date: Sat, 11 Oct 2003 10:32:00 +0100
User-Agent: KMail/1.5
References: <002901c38fcd$5e4d0780$1f00a8c0@middinkcomp>
In-Reply-To: <002901c38fcd$5e4d0780$1f00a8c0@middinkcomp>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200310111032.00580.dev@archonet.com>
X-Virus-Scanned: by AMaViS snapshot-20020531
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/115
X-Sequence-Number: 15515

On Saturday 11 October 2003 08:57, Muhyiddin A.M Hayat wrote:
> Where can i find a complete full terminated database schema in SQL?
>
> I want to see a real complete database schema with views, triggers..
> etc,...

Good places to start are:
  http://freshmeat.net/
  http://sourceforge.net/
That's not to say all the projects are high-quality, but you can probably find 
something that will suit your needs.

There's a lot of good information linked from http://techdocs.postgresql.org/ 
too.

-- 
  Richard Huxton
  Archonet Ltd



From dev@archonet.com Sat Oct  11 09:36:52 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 2D2E1D1B4F8
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 09:36:52 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 30587-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 06:36:11 -0300 (ADT)
Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net
	[194.217.242.88])
	by svr1.postgresql.org (Postfix) with ESMTP id 5B233D1B51B
	for <pgsql-sql@postgresql.org>; Sat, 11 Oct 2003 06:36:05 -0300 (ADT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-30.mail.demon.net with esmtp (Exim 3.35 #1)
	id 1A8GAX-0009R1-0U; Sat, 11 Oct 2003 10:36:13 +0100
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP
	id A9AAB17903; Sat, 11 Oct 2003 10:36:11 +0100 (BST)
Received: from client17.archonet.com (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 0652B1695D; Sat, 11 Oct 2003 10:36:10 +0100 (BST)
From: Richard Huxton <dev@archonet.com>
To: "Muhyiddin A.M Hayat" <middink@indo.net.id>,
	<pgsql-sql@postgresql.org>
Subject: Re: PL/PGSQL TUTORIAL
Date: Sat, 11 Oct 2003 10:36:10 +0100
User-Agent: KMail/1.5
References: <002901c38fcd$5e4d0780$1f00a8c0@middinkcomp>
In-Reply-To: <002901c38fcd$5e4d0780$1f00a8c0@middinkcomp>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200310111036.10425.dev@archonet.com>
X-Virus-Scanned: by AMaViS snapshot-20020531
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/116
X-Sequence-Number: 15516

On Saturday 11 October 2003 08:57, Muhyiddin A.M Hayat wrote:
> Where can i find a complete full terminated database schema in SQL?
>
> I want to see a real complete database schema with views, triggers..
> etc,...

Oh - while I'm thinking of it, a couple of applications it might be worth 
looking at are OpenACS or Bricolage, both web-based content-management 
systems.

-- 
  Richard Huxton
  Archonet Ltd



From rmello@cc.usu.edu Sat Oct  11 23:49:06 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id AB8DAD1B4F2
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 23:49:06 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 49998-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Oct 2003 20:48:28 -0300 (ADT)
Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.103])
	by svr1.postgresql.org (Postfix) with ESMTP id 5EF56D1B4EF
	for <pgsql-sql@postgresql.org>; Sat, 11 Oct 2003 20:48:01 -0300 (ADT)
Received: from roberto by brasileiro.net with local (Exim 3.36 #1 (Debian))
	id 1A8TSc-0002CY-00; Sat, 11 Oct 2003 17:47:46 -0600
Date: Sat, 11 Oct 2003 17:47:46 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: Richard Huxton <dev@archonet.com>
Cc: "Muhyiddin A.M Hayat" <middink@indo.net.id>,
	pgsql-sql@postgresql.org
Subject: Re: PL/PGSQL TUTORIAL
Message-ID: <20031011234746.GA8370@cc.usu.edu>
References: <002901c38fcd$5e4d0780$1f00a8c0@middinkcomp>
	<200310111036.10425.dev@archonet.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <200310111036.10425.dev@archonet.com>
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/124
X-Sequence-Number: 15524

On Sat, Oct 11, 2003 at 10:36:10AM +0100, Richard Huxton wrote:
> 
> Oh - while I'm thinking of it, a couple of applications it might be worth 
> looking at are OpenACS or Bricolage, both web-based content-management 
> systems.

OpenACS is not a content management system, but it provides a couple such
systems. OpenACS is a toolkit to build community-based web sites, handling
all the "low-level" stuff (sessions, authentication, content storage,
etc.) and providing many applications that use the toolkit, from content
management systems, to e-commerce, news, FAQs, blog, to an entire online
education vertical application: dotLRN (www.dotlrn.org)

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +