If I can not, I will have to stay on MS Sqlsrever 2008.
Maybe MS front-end app and MS back-end app is best choice.
Ilija
From: Willy-Bas Loos <willybas@gmail.com> To: Ilija Vidoevski <ilija.vidoevski@yahoo.com> Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org> Sent: Friday, May 25, 2012 3:01 PM Subject: Re: [NOVICE] return values(table) from stored function from MS visual foxpro
wait, are you sure that you are running the right function? the function is defined by it's input fields(incl types), so a_getkonta_table(mkontoa character varying, mkontob character varying) is a different function from a_getkonta_table(mkontoa char, mkontob char) so you would have 2 functions.
>Other fields contain data like name, adress ... Other fields?? Oh, you mean you have a key-value approach?
i can't really say anything about odbc or foxpro there is a seperate list for odbc by the way: http://archives.postgresql.org/pgsql-odbc/
Other fields contain data like name, adress (street, number), city, country etc... and must be char or varchar.
I simply can not understand why when I retrive data from the stored function lenght of returnet fields based od char or varchar table field is 254 char.