Re: [SQL] Linked Lists example.

2003-09-14 Thread Rudi Starcevic
Jesse, >> This approach probably wouldn't work out very well if you needed to pull the content out of the database on every view because there are >> lots of queries and loops involved in following the list. Yes I see. As usual with web development the 'flow of information' dictates alot in whi

Re: [SQL] Linked Lists example.

2003-09-14 Thread Rudi Starcevic
Jesse, Thanks - that's a good example. Could you also have built you CMS solution without linked lists ? I'm curious to see if the rule 'there's more than one way to the top of the mountain' applies here as it usualy does. Cheers Rudi. Jesse Scott wrote: In my current CMS project, I use a link

[SQL] Linked Lists example.

2003-09-14 Thread Rudi Starcevic
Hi, Can anyone give me a real world example of where a 'linked list' would be used in PostgreSQL or SQL in general. Just been reading up a little on them and am wondering how/when to use them. Many thanks Rudi. ---(end of broadcast)--- TIP 9: the p