[SQL] Treating result of subselect as row

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 (subselec

[SQL] Bitemporal - problem with correalated subquery?

Hi there, This is my first time posting in here and I'm hoping somebody can point out where I am going wrong? I am currently trying to use Bitemporal tables. By this I mean a table with a valid times and transaction times. These topics are covered by Joe Celko and Richard Snodgrass in their res