Combining two resources PHP

I have two postgres queries that i execute using PHP and both of them result a Resource, is it开发者_开发知识库 possible to combine or concatenate these two resources?

---

If the queries produce the same resultset layout (same number of columns, all of same types), then you can concatenate the queries:

SELECT   *
FROM     mytable1
WHERE    ...
UNION ALL
SELECT   *
FROM     mytable2
WHERE    ...

---

If one or both queries give a single row of output but have different formats, then it may be more efficient to use cartesian product to retrieve the values in a single operation, e.g.

SELECT singlerow.*, multirow.*
FROM singlerow, multirow
WHERE singlerow.id=1
AND mutlrow.value>10;

C.