Hello,
I have a table with two attributes x and y. The table is indexed on y.
Now, From a C program I want to fetch first n tuples from the table by
doing an indexscan(on index y) on the table. what should I do?
Currently I am able to do it using a cursor(using a select stmt that
forces an inde
Hello ,
I want to fecth random rows from a table ... I have defined a cursor
like
EXEC SQL DECLARE C CURSOR FOR SELECT * FROM tablename ;
Now I want to fectch nth row from the table without actually having to
fetch all n-1 rows before i get to the nth row of the table
Any help is most w
Hello Thomas,
I have used the same thing and it does work for me I was also getting
similar problems initially
What does your trigger do? does it insert a tuple back into the table? if
yes then that is your problem ... coz the insert will fire another trigger
and this may continue endles
