RECURSIVE FUNCTIONS AND C

B> From: Bruce Bramhall <bruce@tkg.com> > Subject: recursive functions and cursors > Date: 13 Jun 1995 12:42:19 GMT > Organization: The Kernel Group, Inc. > To: informix-list@rmy.emory.edu B> I have a table that contains a hiearchy of items where where each record > references another record as its parent. B> tableA > itemid parent > A A > B A > C A > D B > E B > F C > G C I didn't go through your whole message, but noticed that you have a table which has the same relationships as one which we are prototyping. We determined that if the itemid = parent then parent would be either null or a predetermined invalid value (we haven't decided, but will probably go the null route). This can help in a select statement. --- ~ SPEED 1.40 [NR] ~