questions

I have a little problem with arrays. I,ve defined a type dbref. It has
two fields: char type[200] and char record[200]. My prolem is that I
can't insert a row into a table which has an attribute with type
dbref[2].
For instance:
Create table boci (hapci dbref[2]);
How can I insert a row into this table?
Please help me!

    My next problem is SPI interface. I have used LIBPQ but I need SPI. I
have read a description in PostgrSQL Programmer's Guide, but I
understand nearly nothing. Please write me where I can find a better
description about SPI!

    I have to treat very big tables from my C program. I update every
attribute with update command. When I update an attribute, I must go
through every tuple of the table. It takes a long time. I write you a
little piece of my program:

sprintf(buff, "CREATE TABLE boci (tup_num int, hapci int)");
PQexec(conn, buff);
for (i=0; i<10000; i++)
{
    sprintf(buff, "INSERT INTO boci VALUES(i)");
    PQexec(conn, buff);
}

for (i=0; i<10000; i++)
{
    x = GetValue(); /* GetValue isn't an interesting function */
    sprintf(buff, "UPDATE boci SET hapci = %d WHERE tup_num = %d", x,
i);
    PQexec(conn, buff);
}

I don't want to update every tuple indvidually but I want to prepare a
'block write'. I hope you understand what I'd like to.
Can you give me a good method for saving a long time? I need a program
that is about 10 times faster than mine.

Thanks for your attention!

gyurika@prolan.hu