[SQL] Connecting to Postgres from Windows

Hi I am connecting to postgres in a java program running on windows 98. a) I am running the postgres on linux with -i option b) I am using the url as "jdbc:postgresql://:5432/testdb" The program is unable to resolve the url? The same thing happens when executing the java code on the linux mach

[SQL] user defined functions in Java ?

Hi, I am a beginner in postgres. a) I understand from postgres documentation that a user-defined function can be in sql or C language. Do any of you have an idea if such a function can be defined in Java ? b) if some one has examples of code, can you please forward the same ? Regards Uma.

[SQL] Query on array-elements inside object

Hi, I am new to Postgres as well as object database. Wondering if one of you can tell me on how to write a sql query to select an object that has a particular element in an array. Example If I create an object-table with 2 elements. a) PatientID -> numeric b) DiseaseArray -> array of text -