pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedunsubscribe
20+ messages / 15 participants
[nested] [flat]
* unsubscribe
@ 1999-02-19 12:57 Zinchik <zinchik@megahertz.net>
0 siblings, 0 replies; 20+ messages in thread
From: Zinchik @ 1999-02-19 12:57 UTC (permalink / raw)
To: pgsql-docs@hub.org
At 11:00 PM 2/18/99 -0500, you wrote:
>
>pgsql-docs-digest Thursday, February 18 1999 Volume 01 : Number 411
>
>
>
>Index:
>
>A little nitpick correction
>Can this be added to manual?
>
>----------------------------------------------------------------------
>
>Date: Thu, 18 Feb 1999 15:34:33 +0100
>From: Hans de Goede <j.w.r.degoede@et.tudelft.nl>
>Subject: A little nitpick correction
>
>Hi all,
>
>Well you said you wanted to know any errors int he docs:
>In the tutorial chapter 3 getting started:
>in Managing a database:
>The followign example code is given:
>- ---
>% psql mydb
>
>You will be greeted with the following message:
>
>Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: template1
>
>mydb=>
>- ---
>Template 1 should of course be mydb over here.
>since I'm just learning postgress I'm digging through the tutorial. I'll
>lett you know
>if I find more mistakes.
>
>Regards,
>Hans
>
>------------------------------
>
>Date: Thu, 18 Feb 1999 20:56:06 -0500
>From: Fred Wilson Horch <fhorch@ecoaccess.org>
>Subject: Can this be added to manual?
>
>I found this to be an extremely useful message to help understand how
>aggregates and joins work. Can this be included in the manual for 6.5?
>
>In particular, the following commands would be nice to use as examples
>in the chapters on joins and using aggregates:
>
>> -- all that have ever existed (most recent)
>> SELECT * from stuff* s1 WHERE d = (SELECT MAX(d) FROM stuff* s2 WHERE
>> s1.id = s2.id);
>> -- records @ or before '2/2/1999 13:50:00'
>> SELECT * from stuff* s1 WHERE d = (SELECT MAX(d) FROM stuff* s2 WHERE
>> s1.id = s2.id and s2.d <= '2/2/1999 13:50:00');
>
>Just a suggestion,
>- --Fred
>
>Full message:
>
>> RE: [GENERAL] Missing features ?
>>
>> From: "Jackson, DeJuan" <djackson@cpsgroup.com>
>> To: Remigiusz Sokolowski <rems@gdansk.sprint.pl>, Joerg
>> Huettmann <joerg.huettmann@informatik.tu-chemnitz.de>
>> Subject: RE: [GENERAL] Missing features ?
>> Date: Tue, 2 Feb 1999 13:55:39 -0600
>>
>> [Time travel] was depreciated because of it's high overhead verses it's
>> utility. In other words not enough people were using it to make it
>> worth the cost in everyone's database. There are many way that you can
>> design the same type of system in your own database. I suggest using
>> inheritance and RULES. Example (assuming id is PRIMARY KEY):
>>
>> CREATE TABLE stuff (
>> id INT,
>> t TEXT,
>> d DATETIME DEFAULT(DATETIME(NOW()))
>> );
>> CREATE UNIQUE INDEX stuff_pkey ON stuff(id);
>> CREATE TABLE old_stuff () INHERITS (stuff);
>> CREATE RULE del_stuff AS ON DELETE TO stuff DO
>> INSERT INTO old_stuff SELECT old.*;
>> CREATE RULE up_stuff AS ON UPDATE TO stuff DO
>> INSERT INTO old_stuff SELECT old.*;
>> INSERT INTO stuff (id, t) VALUES (1, 'Hello there.');
>> INSERT INTO stuff (id, t) VALUES (2, 'Hi there.');
>> INSERT INTO stuff (id, t) VALUES (3, 'Hello there again.');
>> INSERT INTO stuff (id, t) VALUES (4, 'Hi there once more.');
>> INSERT INTO stuff (id, t) VALUES (5, 'Hello there.');
>> UPDATE stuff SET d=now(), t='Hi' WHERE t='Hello there.';
>> DELETE FROM stuff WHERE id=2;
>> DELETE FROM stuff WHERE id=5;
>> -- current snapshot
>> SELECT * from stuff;
>> -- all that have ever existed (most recent)
>> SELECT * from stuff* s1 WHERE d = (SELECT MAX(d) FROM stuff* s2 WHERE
>> s1.id = s2.id);
>> -- records @ or before '2/2/1999 13:50:00'
>> SELECT * from stuff* s1 WHERE d = (SELECT MAX(d) FROM stuff* s2 WHERE
>> s1.id = s2.id and s2.d <= '2/2/1999 13:50:00');
>>
>> I think you get the idea. If you want to store the date an item was
>> delete/updated rather than when it was inserted the rules become:
>> CREATE RULE del_stuff AS ON DELETE TO stuff DO
>> INSERT INTO old_stuff SELECT old.id, old.t, datetime(now());
>> CREATE RULE up_stuff AS ON UPDATE TO stuff DO
>> INSERT INTO old_stuff SELECT old.id, old.t, datetime(now());
>>
>> Hope this helps,
>> -DEJ
>
>------------------------------
>
>End of pgsql-docs-digest V1 #411
>********************************
>
http://www.zinchik.net
* Tell a man that there are 400 billion stars and he'll believe
you. Tell him a bench has wet paint and he has to touch it.
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 1999-04-14 16:02 Andre Smith <alsmith@digex.net>
0 siblings, 0 replies; 20+ messages in thread
From: Andre Smith @ 1999-04-14 16:02 UTC (permalink / raw)
To: pgsql-docs
unsubscribe
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 1999-07-19 19:48 Marek Goc <marek.goc@lear.com.pl>
0 siblings, 0 replies; 20+ messages in thread
From: Marek Goc @ 1999-07-19 19:48 UTC (permalink / raw)
To: pgsql-docs@hub.org
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 1999-10-12 13:30 vincent sarucyel <lv68@hotmail.com>
0 siblings, 0 replies; 20+ messages in thread
From: vincent sarucyel @ 1999-10-12 13:30 UTC (permalink / raw)
To: pgsql-docs
Hi!
I d like to unsubcribe but I forgot how to. Can someone tell me?
The subcription adress is E97249@essec.fr
Thanks!! Vincent.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2000-03-06 16:17 catalin@hayes.bru.ed.ac.uk
0 siblings, 0 replies; 20+ messages in thread
From: catalin@hayes.bru.ed.ac.uk @ 2000-03-06 16:17 UTC (permalink / raw)
To: docs@postgreSQL.org
unsubscribe
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2000-03-07 10:55 catalin@hayes.bru.ed.ac.uk
0 siblings, 0 replies; 20+ messages in thread
From: catalin@hayes.bru.ed.ac.uk @ 2000-03-07 10:55 UTC (permalink / raw)
To: pgsql-docs
unsubscribe
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2000-03-08 11:54 catalin@hayes.bru.ed.ac.uk
0 siblings, 0 replies; 20+ messages in thread
From: catalin@hayes.bru.ed.ac.uk @ 2000-03-08 11:54 UTC (permalink / raw)
To: pgsql-docs
unsubscribe
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2001-03-19 02:54 willy lubamba <willy@afrinet.cd>
0 siblings, 0 replies; 20+ messages in thread
From: willy lubamba @ 2001-03-19 02:54 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; pgsql-docs; Tom Lane <tgl@sss.pgh.pa.us>
unsubscribe
----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: <pgsql-hackers@postgresql.org>; <pgsql-docs@postgresql.org>
Sent: Monday, March 19, 2001 11:37 PM
Subject: [DOCS] src/test/regress/README duplicates SGML material
> Is it really necessary to maintain identical text in the test README
> file and in the SGML docs? I'm sorely tempted to remove the README
> rather than double-editing yet again.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 20+ messages in thread
* UNSUBSCRIBE
@ 2003-11-05 12:50 Renê Salomão <rene@ibiz.com.br>
0 siblings, 0 replies; 20+ messages in thread
From: Renê Salomão @ 2003-11-05 12:50 UTC (permalink / raw)
To: pgsql-docs
UNSUBSCRIBE
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2005-08-02 19:39 Norm Costa <ncosta@expertss.com>
0 siblings, 0 replies; 20+ messages in thread
From: Norm Costa @ 2005-08-02 19:39 UTC (permalink / raw)
To: pgsql-docs
unsubscribe
________________________________________________________________
Sent via the WebMail system at expertss.com
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2006-08-09 05:23 Andrzej B.J.Schulz <jaskierbard@poczta.onet.pl>
0 siblings, 3 replies; 20+ messages in thread
From: Andrzej B.J.Schulz @ 2006-08-09 05:23 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2006-08-09 09:24 Gourish Singbal <gourish@gmail.com>
parent: Andrzej B.J.Schulz <jaskierbard@poczta.onet.pl>
2 siblings, 1 reply; 20+ messages in thread
From: Gourish Singbal @ 2006-08-09 09:24 UTC (permalink / raw)
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2006-08-09 09:25 Gourish Singbal <gourish@gmail.com>
parent: Gourish Singbal <gourish@gmail.com>
0 siblings, 2 replies; 20+ messages in thread
From: Gourish Singbal @ 2006-08-09 09:25 UTC (permalink / raw)
To: pgsql-performance@postgresql.org
---------- Forwarded message ----------
From: Gourish Singbal <gourish@gmail.com>
Date: Aug 9, 2006 12:24 PM
Subject: unsubscribe
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
--
Best,
Gourish Singbal
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 20+ messages in thread
* Fwd: unsubscribe
@ 2006-08-09 09:26 Gourish Singbal <gourish@gmail.com>
parent: Gourish Singbal <gourish@gmail.com>
1 sibling, 0 replies; 20+ messages in thread
From: Gourish Singbal @ 2006-08-09 09:26 UTC (permalink / raw)
To: pgsql-docs; pgsql-hackers@postgresql.org
---------- Forwarded message ----------
From: Gourish Singbal <gourish@gmail.com>
Date: Aug 9, 2006 12:25 PM
Subject: unsubscribe
To: pgsql-performance@postgresql.org
---------- Forwarded message ----------
From: Gourish Singbal <gourish@gmail.com>
Date: Aug 9, 2006 12:24 PM
Subject: unsubscribe
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
--
Best,
Gourish Singbal
--
Best,
Gourish Singbal
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 20+ messages in thread
* unsubscribe
@ 2006-08-09 11:58 Mohan R <mohanr@bsil.com>
parent: Andrzej B.J.Schulz <jaskierbard@poczta.onet.pl>
2 siblings, 1 reply; 20+ messages in thread
From: Mohan R @ 2006-08-09 11:58 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
Please unsubscribe
Regards
R Mohan
Blue Star Infotech Limited
T : +91-22-6695696
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: unsubscribe
@ 2006-08-09 12:52 Devrim GUNDUZ <devrim@commandprompt.com>
parent: Mohan R <mohanr@bsil.com>
0 siblings, 0 replies; 20+ messages in thread
From: Devrim GUNDUZ @ 2006-08-09 12:52 UTC (permalink / raw)
To: Mohan R <mohanr@bsil.com>; +Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Hello,
On Wed, 2006-08-09 at 17:28 +0530, Mohan R wrote:
> Please unsubscribe
Use http://www.postgresql.org/community/lists/subscribe and select
unsubscribe from action box.
You must do it by yourself.
-HAND,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: unsubscribe
@ 2006-08-09 13:00 Bill Moran <wmoran@collaborativefusion.com>
parent: Gourish Singbal <gourish@gmail.com>
1 sibling, 0 replies; 20+ messages in thread
From: Bill Moran @ 2006-08-09 13:00 UTC (permalink / raw)
To: Gourish Singbal <gourish@gmail.com>; +Cc: pgsql-performance@postgresql.org
In response to "Gourish Singbal" <gourish@gmail.com>:
If you look in the mail headers:
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
--
Bill Moran
Collaborative Fusion Inc.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: unsubscribe
@ 2006-08-17 05:16 Mohan R <mohanr@bsil.com>
parent: Andrzej B.J.Schulz <jaskierbard@poczta.onet.pl>
2 siblings, 1 reply; 20+ messages in thread
From: Mohan R @ 2006-08-17 05:16 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
--
Regards
R Mohan
Blue Star Infotech Limited
T : +91-22-66956969
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: unsubscribe
@ 2006-08-17 06:40 lst_hoe01@kwsoft.de
parent: Mohan R <mohanr@bsil.com>
0 siblings, 0 replies; 20+ messages in thread
From: lst_hoe01@kwsoft.de @ 2006-08-17 06:40 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
Zitat von Mohan R <mohanr@bsil.com>:
> --
>
> Regards
> R Mohan
> Blue Star Infotech Limited
> T : +91-22-66956969
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&func=lists-long-full&extra=pgs...
^ permalink raw reply [nested|flat] 20+ messages in thread
* Unsubscribe
@ 2007-09-24 07:43 mp torre <torre@obs-vlfr.fr>
0 siblings, 0 replies; 20+ messages in thread
From: mp torre @ 2007-09-24 07:43 UTC (permalink / raw)
To: Patches <pgsql-patches@postgresql.org>; pgsql-docs
More thanks for all the information you give
regards
mp torre
--
=======================================
MP TORRE
Observatoire Oceanologique
Base de données PROOF / CYBER
Cas. Nicolas, Quai de la Darse, BP 8
06238 VILLEFRANCHE SUR MER - FRANCE
(mel): torre@obs-vlfr.fr
(T): 04.93.76.38.77
(F): 04.93.76.38.73
^ permalink raw reply [nested|flat] 20+ messages in thread
end of thread, other threads:[~2007-09-24 07:43 UTC | newest]
Thread overview: 20+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-19 12:57 unsubscribe Zinchik <zinchik@megahertz.net>
1999-04-14 16:02 unsubscribe Andre Smith <alsmith@digex.net>
1999-07-19 19:48 unsubscribe Marek Goc <marek.goc@lear.com.pl>
1999-10-12 13:30 unsubscribe vincent sarucyel <lv68@hotmail.com>
2000-03-06 16:17 unsubscribe catalin@hayes.bru.ed.ac.uk
2000-03-07 10:55 unsubscribe catalin@hayes.bru.ed.ac.uk
2000-03-08 11:54 unsubscribe catalin@hayes.bru.ed.ac.uk
2001-03-19 02:54 unsubscribe willy lubamba <willy@afrinet.cd>
2003-11-05 12:50 UNSUBSCRIBE Renê Salomão <rene@ibiz.com.br>
2005-08-02 19:39 unsubscribe Norm Costa <ncosta@expertss.com>
2006-08-09 05:23 unsubscribe Andrzej B.J.Schulz <jaskierbard@poczta.onet.pl>
2006-08-09 09:24 ` Gourish Singbal <gourish@gmail.com>
2006-08-09 09:25 ` Gourish Singbal <gourish@gmail.com>
2006-08-09 09:26 ` Gourish Singbal <gourish@gmail.com>
2006-08-09 13:00 ` Bill Moran <wmoran@collaborativefusion.com>
2006-08-09 11:58 ` Mohan R <mohanr@bsil.com>
2006-08-09 12:52 ` Devrim GUNDUZ <devrim@commandprompt.com>
2006-08-17 05:16 ` Mohan R <mohanr@bsil.com>
2006-08-17 06:40 ` lst_hoe01@kwsoft.de
2007-09-24 07:43 Unsubscribe mp torre <torre@obs-vlfr.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox