Archive for September 1st, 2009

Converting Enterprisedb Postgres Plus XML Array To Array

In Postgres Plus Advanced Server 8.3R2, there are times when you want to query a table using values passed in as XML.  Here's an example. First we'll create a table and insert a few values: CREATE TABLE NAMES (FNAME VARCHAR2(50)); Table created. INSERT INTO NAMES VALUES ('MIKE'); 1 row INSERTED. INSERT INTO NAMES VALUES...
Read More