Re: [GENERAL] insert with select as value

2004-06-23 Thread Bruno Wolff III
On Wed, Jun 23, 2004 at 13:42:12 +0200, Milos Prudek <[EMAIL PROTECTED]> wrote: > >If your purpose in doing this is just to generate unique keys, you should > >be using sequences instead. > > I would need 150 separate sequences, because each idsection needs its > own, independent sequence of id

Re: [GENERAL] insert with select as value

2004-06-23 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Milos Prudek <[EMAIL PROTECTED]> writes: >> If your purpose in doing this is just to generate unique keys, you should >> be using sequences instead. > I would need 150 separate sequences, because each idsection needs its > own, independent sequence of idthread. Wh

Re: [GENERAL] insert with select as value

2004-06-23 Thread Milos Prudek
If your purpose in doing this is just to generate unique keys, you should be using sequences instead. I would need 150 separate sequences, because each idsection needs its own, independent sequence of idthread. Note that you probably want to lock the table before doing this or two transactions ru