Hi, there
I believe that if you create a function with PL/pgSQL that take a text array as
parameter:
create function cancer(_text) returns bool as '
declare
.
begin
use a while loop here to scan the whole array
if string match 'cancer' immediately return true otherwise
end the loop
return fal
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
-
