Re: [GENERAL] self ordering list

2007-12-22 Thread Michael Glaesemann
On Dec 21, 2007, at 15:19 , Bryan Wilkerson wrote: I've implemented in my model code but it has some deadlock issues and I really strongly have believed all along that this belongs in the db anyway. Implementing the above with triggers is a tricky problem because the trigger would key off

Re: [GENERAL] self ordering list

2007-12-21 Thread brian
Bryan Wilkerson wrote: My first question concerns self ordering lists. Basically, a numeric column that automatically maintains an order but allows arbitrary reordering by the user. For example, a media playlist or the priority of workitems within a parent container ;) This seems like a co

[GENERAL] self ordering list

2007-12-21 Thread Bryan Wilkerson
Hello to all. I'm new to the list and have only been engineering on postgresql for about a year. I have solved some neat problems in that time and will gladly give back to the community. I'll try to contribute as much as startup time permits. My first question concerns self ordering lists