X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id B240611F6971 for ; Sat, 22 Apr 2006 12:57:43 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.358 X-Spam-Level: X-Spam-Status: No, score=-2.358 required=5 tests=[AWL=0.241, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id 7hEruyw42z6e for ; Sat, 22 Apr 2006 12:57:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svana.org (svana.org [125.62.94.225]) by postgresql.org (Postfix) with ESMTP id 5AE2211F628D for ; Sat, 22 Apr 2006 12:57:35 -0300 (ADT) Received: from kleptog by svana.org with local (Exim 4.50) id 1FXKUB-0002n9-DM; Sun, 23 Apr 2006 01:57:27 +1000 Date: Sat, 22 Apr 2006 17:57:27 +0200 From: Martijn van Oosterhout To: Gevik Babakhani Cc: Alvaro Herrera , Dhanaraj M , pgsql-hackers@postgresql.org Subject: Re: TODO items.. Message-ID: <20060422155727.GG7398@svana.org> Reply-To: Martijn van Oosterhout References: <4449D7FB.905@sun.com> <20060422152445.GB12686@surnet.cl> <1145720248.29124.2.camel@voyager.truesoftware.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="qoTlaiD+Y2fIM3Ll" Content-Disposition: inline In-Reply-To: <1145720248.29124.2.camel@voyager.truesoftware.net> X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: User-Agent: Mutt/1.5.9i X-SA-Exim-Connect-IP: X-SA-Exim-Mail-From: kleptog@svana.org X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false X-Archive-Number: 200604/799 X-Sequence-Number: 82522 --qoTlaiD+Y2fIM3Ll Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Apr 22, 2006 at 05:37:28PM +0200, Gevik Babakhani wrote: >=20 > > This one means when you do a \dt of a sequence, add a column to display > > the current value. > >=20 >=20 > Perhaps this one will be tricky because you will never be sure to get > the last sequence number when you query for it. The number could change > the moment the query is finished. So could the structure of a table or the definition of a function. That's just a fact of life. Doesn't change the fact that it'd be useful. You need nextval() to actually get a useful value for queries... Have a nice day, --=20 Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to l= itigate. --qoTlaiD+Y2fIM3Ll Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFESlJnIB7bNG8LQkwRAgN9AJ9b0k3OTT0tw5g7phyD4IEdK/lGvQCghAOb 18Smohu8I51DVj+e6gN5ewE= =e9qc -----END PGP SIGNATURE----- --qoTlaiD+Y2fIM3Ll--