Skip site navigation (1) Skip section navigation (2)

Re: records chaining

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: "tvis" <tovises(at)freemail(dot)hu>, pgsql-novice(at)postgresql(dot)org
Subject: Re: records chaining
Date: 2005-04-19 13:59:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
This message, along with your previous one, suggests
that you are trying to limit the size of your tables. 
Is there any good reason for this?  How many records
do you expect to have?  What hardware will you be
running on?

--- tvis <tovises(at)freemail(dot)hu> wrote:
> I need record changing history. Of course I need to
> keep old records, and some how point to it for show
> changes. First of my idea is to make a single column
> in every record pointing to his "parent" but after I
> started thinking how SQL can handle it. Whats your
> opinion, is it possible to write a recursive SELECT
> to get all records back to that whats parent
> reference has no reference (NULL)? At this moment I
> would be happy to know that is it possible - I'm
> only planning and migrating an old database, the
> coding seem to be "far" away.
> Thanks in advance
>     Gbor Rzsa

Do you Yahoo!? 
Plan great trips with Yahoo! Travel: Now over 17,000 guides!


pgsql-novice by date

Next:From: Simon RiggsDate: 2005-04-19 14:46:33
Subject: Re: Postgresql works too slow
Previous:From: Kevin CrenshawDate: 2005-04-19 13:49:44
Subject: Are there any known issues with running MSDE and Postgresql 8.0 on the same machine?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group