On Wed, 3 Mar 2004, [UTF-8] Paulovič Michal wrote: > Yes I know, > > But how you do this at PgSQL????
OK, I just read the response where someone showed me how to make such a table in mysql. What an odd, and non-intuitive behaviour that is. Anyway, first off, upgrade your version of postgresql to 7.4.x . 7.1 is VERY old, and is no longer maintained. IT would suck to develop all this for 7.1 only to find out some minor bug fix gets in your way of upgrading. Next, what you need is a before trigger that will take any row being inserted, select the max(id2) where id1 = whatwereinserting adds one to it and makes that the new id2. Look up before triggers. plpgsql is a good language to do this in. Note that on large tables it WILL BE SLOW. ---------------------------(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