Re: [GENERAL] Achieving ordered update

2010-03-28 Thread Bopolissimus Platypus Jr
On Fri, Mar 26, 2010 at 1:02 AM, Allan Kamau wrote: > A classic problem. I would like to assign integer values (from a > sequence) to records in a table based on the order (of contents) of > other field(s) in the same table. Do you have a simple example? (create table, insert some data, then sho

[GENERAL] shrinking physical space used

2004-11-13 Thread Bopolissimus Platypus Jr
hello all, i've got a database that takes up 4G of space. when i run a script that deletes all rows and then vacuum, the data directory gets down to around 3-3.5G. what i'd like is to get a blank database structure that really contains no data at all, or any unused space at all. apparently tha