Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9AF3D9FC29F for ; Fri, 25 May 2007 15:15:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 41010-02-2 for ; Fri, 25 May 2007 15:15:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mout0.freenet.de (mout0.freenet.de [194.97.50.131]) by postgresql.org (Postfix) with ESMTP id 7B9639FC27A for ; Fri, 25 May 2007 15:15:27 -0300 (ADT) Received: from [194.97.50.135] (helo=mx2.freenet.de) by mout0.freenet.de with esmtpa (Exim 4.68) (envelope-from ) id 1HreJy-0001CH-6O for pgsql-php@postgresql.org; Fri, 25 May 2007 20:15:26 +0200 Received: from lec67-1-81-56-104-13.fbx.proxad.net ([81.56.104.13]:26123 helo=tp570.private.tamay-dogan.net) by mx2.freenet.de with esmtpa (ID asmtp.tdnet@freenet.de) (port 587) (Exim 4.68 #1) id 1HreJy-0000WX-1p for pgsql-php@postgresql.org; Fri, 25 May 2007 20:15:26 +0200 Received: by tp570.private.tamay-dogan.net (sSMTP sendmail emulation); Fri, 25 May 2007 20:15:12 +0200 Date: Fri, 25 May 2007 20:15:12 +0200 From: Michelle Konzack To: pgsql-php@postgresql.org Subject: Re: Application Design: Where to implement historical revisions of objects Message-ID: <20070525181512.GE6097@freenet.de> References: <20070525174108.GA6097@freenet.de> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="VcZjVMblxkg0/8Ur" Content-Disposition: inline In-Reply-To: X-Message-Flag: Improper configuration of Outlook is a breeding ground for viruses. Please take care your Client is configured correctly. Greetings Michelle. X-Disclaimer-DE: Eine weitere Verwendung oder die Veroeffentlichung dieser Mail oder dieser Mailadresse ist nur mit der Einwilligung des Autors gestattet. Organisation: Michelle's Selbstgebrautes X-Operating-System: Linux tp570.private 2.4.27-tp570 X-Uptime: 20:11:20 up 37 min, 6 users, load average: 6.55, 7.27, 5.75 X-Homepage: http://www.debian.tamay-dogan.homelinux.net/ User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/11 X-Sequence-Number: 3800 --VcZjVMblxkg0/8Ur Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Am 2007-05-25 11:07:24, schrieb Colin Ross: > But in the one-table holds all system, the Model Object need to know about > it. > i.e. "Select top 1 from data where serialnumber =3D 3821 order by revisi= on > desc" You do not need to know what the last revision was, since you can automagicaly SELECT the higest one... Thanks, Greetings and nice Day Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant --=20 Linux-User #280138 with the Linux Counter, http://counter.li.org/ ##################### Debian GNU/Linux Consultant ##################### Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSN LinuxMichi 0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com) --VcZjVMblxkg0/8Ur Content-Type: application/pgp-signature; name="signature.pgp" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFGVyewC0FPBMSS+BIRAuG9AKC4NIl2EJFO5fB8of7MOs9PeDnSRwCcC9B7 QDt41qXkS5ju64y6Hbx/w0M= =T8TS -----END PGP SIGNATURE----- --VcZjVMblxkg0/8Ur--