From:
Martijn van Oosterhout <kleptog(at)svana(dot)org>
To:
Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:
Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,pgsql-hackers(at)postgresql(dot)org,Gregory Stark <stark(at)enterprisedb(dot)com>
Subject:
Re: column ordering, was Re: [PATCHES] Enums patch v2
Date:
2006-12-21 15:37:03
Message-ID:
20061221153703.GD14992@svana.org (view raw or flat )
Thread:
2006-12-19 02:34:36 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-19 08:09:47 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2006-12-19 08:23:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-19 14:34:27 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 14:58:48 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2006-12-19 15:11:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 15:22:13 from Gregory Stark <stark(at)enterprisedb(dot)com>
2006-12-19 15:48:41 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 16:25:04 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 03:35:21 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2006-12-20 03:44:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 04:12:50 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 04:29:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 11:33:53 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2006-12-20 14:19:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-20 14:27:13 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 16:20:16 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-20 16:24:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 21:23:49 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2006-12-21 16:26:30 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-20 12:06:54 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:15:05 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 20:17:12 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 14:39:07 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-21 15:27:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-21 15:37:03 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 15:50:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:07:20 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:15:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:27:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-21 16:43:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 17:09:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-22 01:48:49 from Gregory Stark <gsstark(at)mit(dot)edu>
2006-12-22 02:28:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-22 09:25:08 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-30 04:46:27 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-02 05:43:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-21 16:47:56 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:59:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:06:53 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-21 16:11:46 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:18:02 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-20 12:26:59 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-20 13:20:14 from Kenneth Marshall <ktm(at)it(dot)is(dot)rice(dot)edu>
2006-12-20 13:38:30 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:11:48 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-20 14:36:32 from Richard Huxton <dev(at)archonet(dot)com>
2006-12-20 13:59:21 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-19 15:19:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 01:39:58 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-20 11:03:11 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:49:32 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 08:51:01 from David Fetter <david(at)fetter(dot)org>
2006-12-19 09:58:48 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-20 02:00:48 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-20 01:23:02 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2007-02-02 03:50:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-02 15:54:44 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-14 00:03:47 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2007-02-21 17:06:10 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers pgsql-patches
On Thu, Dec 21, 2006 at 10:27:12AM -0500, Andrew Dunstan wrote:
> >Um, surely you meant "offset the physical numbers". Imho the logical
> >numbers
> >need to stay 1-n, because those numbers are used way more often and are
> >more user visible than the physical.
> >
> >
> >
>
> I don't think we should expose the offset to user view at all - this is
> just for internal use, no?
The thing is, physical index numbers has meaning, the logical index
number does not. In a view definition we're going to store the physical
index, not the logical one, for example. We don't want rearranging
columns to invalidate view definitions or plans.
The number of places needing the logical index are not that man,
relativelyy, and given it has no intrinsic meaning, it's better to give
it a numeric value which is obviously abritrary (like 10001).
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2006-12-21 15:47:52Subject : Re: New version of money type Previous :From : Chris BrowneDate : 2006-12-21 15:32:51Subject : Re: Stats Collector Oddity
pgsql-patches by date
Next :From: Tom LaneDate: 2006-12-21 15:50:59Subject : Re: column ordering, was Re: [PATCHES] Enums patch v2 Previous :From : Andrew DunstanDate : 2006-12-21 15:27:12Subject : Re: column ordering, was Re: [PATCHES] Enums patch v2
