Recent content by ZdenekMach

Hi all, could you please help me? I am doing program in C# and my WebService could not access the Postgre Database. I hade just one another program which used Npgsql version 7.0.0 and now I have 1.0.0.0 and dont know why it cant work. The method NpgsqlConnection.Open() doesnt work. I gave...

Solved :-) http://www.thescripts.com/forum/thread174740.html As I said, I am a newbi.

Else could I execute immediate in function returns set of something? if I create function returns setof, and than I call the function, it tells me that end of function was reached but no return found.

Sorry, but I am novice in postgreSQL so :-) I have created this function, but it desnt work. It still tells me: "ERROR: syntax error at or near "and"na znaku 630" -- Function: eds_getaccountsdataset(mustbechecked bool, applicatestatus bool, applicatedifferentmaker bool, currentloggedusername...

Could you someone please explain me, why I could not index array with some variable. for example in for cycle I try to go throw the whole array and increment index. But it doesnt work. If I put there just number e.g. array[3], it works well.

Hi all, I am just trying to write stored funtion on PostgreSQL database with PG Admin III and find out a trouble. This is my function, which shoul be use as ordinary String.Split : -- Function: split_varchar_to_int(p_list "varchar", p_del "varchar") -- DROP FUNCTION...

Hi all, I am just trying to write stored funtion on PostgreSQL database with PG Admin III and find out a trouble. This is my function, which shoul be use as ordinary String.Split : -- Function: split_varchar_to_int(p_list "varchar", p_del "varchar") -- DROP FUNCTION...