Using SQL and Postgre on the same machine
We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

Answer Question   |  February 24, 2010  9:21 PM
Database API, Postgres, PostgreSQL, SQL, SQL Server 2000, Tomcat

return array in postgres
when i execute following function in postgres, it gives me null. select get_strelements(’1000-2000-3000-4000′,array[''::text]); here, “get_strelements” function is as follows: CREATE OR REPLACE FUNCTION “public”.”get_strelements” (str varchar, dummyarr “pg_catalog”.”anyarray”) RETURNS “pg_catalog”.”anyarray” AS $body$ declare —————————————————————————————————————— len integer; len1 integer; len2 integer; v_str varchar; repl_char varchar := ‘-’; i integer; num numeric; noarr varchar[10]; splstr varchar; —————————————————————————————————————— [...]

Answer Question   |  June 12, 2008  6:48 AM
Database, Postgres