| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
| Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Creating a Pseudocolumn |
| Date: | 2006-05-15 15:36:48 |
| Message-ID: | 20060515153648.GF21506@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, May 15, 2006 at 11:17:41AM -0400, Jonah H. Harris wrote:
> On 5/15/06, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> >tableoid is a pseudo-column like you mean, perhaps you should look how
> >that works.
>
> I thought tableoid was a system column with a physical representation
> on the tuple itself? I don't want any on-disk representation of my
> pseudocolumn... just assigned at runtime similar to rownum.
Tableoid is certainly not stored on disk (waste of space) but retreived
specially whenever someone asks for the tableoid column. See
heap_getsysattr in access/common/heaptuple.c.
All you need to do is decide where you are going to store the level
number and add it as a system attribute (negative attribute number).
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-05-15 15:39:41 | Re: [PORTS] Compiling on 8.1.3 on Openserver 5.05 |
| Previous Message | Jonah H. Harris | 2006-05-15 15:17:41 | Re: Creating a Pseudocolumn |