Go in order by id, starting with id=1 (which has a created_ts already), and check if a row has a created_ts; if null, enter something just a bit later (I say 2 minutes) than the *previous* id.
I don't *think* this can be done in pure SQL, will need a helper script (whether Haskell, Ruby, pgpl, or whatever) I expect.
Why not just set all NULL to the same time and be done with it? _______________________________________________ Dev mailing list [email protected] https://lists.snowdrift.coop/mailman/listinfo/dev
