On Mon, 15 Jul 2002, Christopher Kings-Lynne wrote: > However, I'm not happy with the way dropped columns are renamed. I want to > give them a name that no-one would ever want to use as a legit column name. > ... > We could name the fields "________dropped_x" sort of thing perhaps????
I suggest you _dropped_N_XXXXXXXXXXXXXXXX where "n" is that same sequence number (1, 2, 3, etc.) and the Xs are the hexedecimal representation of a 64-bit random number. So you'd get names like "_dropped_2_719fe940a46eb39c". This is easy to generate and highly unlikley to conflict with anything. cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
