NEED HELP COPY TO DYNAMIC OUTPUT FILE

Hi admin, i'm gie from indonesia

i wanna ask you how to make a dynamic output file from command COPY TO ?

i have tried this :

BEGIN
i:=0;
j:=10;
WHILE i < j LOOP
COPY (SELECT * FROM country) TO '/usr/proj/' || i || '.txt'; // need attention here
END LOOP;
RETURN;
END

but it seems getting wrong, so what the right syntax's ?

Sorry for my bad english and thanks in advance

Coba Yahoo! Messenger 9.0 baru. Lengkap dengan segala yang Anda sukai tentang Messenger! http://id.messenger.yahoo.com