Hi,
If I have a subselect that returns one row, then how can I use this in
expressions that expects row constructors in the operands, like OVERLAPS or
IN ?
SELECT (subselect1) OVEPLAPS (subselect2) -- both subselect returns one
row and two columns
OR:
SELECT (SubselectWithOneRow) IN (subselect2) -- but here subselect2 may
return many rows, but column counts are equal
I tried these in 8.2 without success.
Thanks,
Otto