[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 - This DiseaseArray has elements like "cancer", "tb" etc... Now how will I write a sql-query to select all patients that have "cancer" Any pointers will be helpful. regards, Uma. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
[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. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
[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 machine (same as that running postgres). However if I put 127.0.0.1 (or localhost) instead of , it resolves and works fine. Any suggestions on what could be the problem ? Regards Uma. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
