With a statement such as:

select n.NODE, h.ROUTE_UPDATED,
list( h.ROUTE_INDEX ) LI, list( h.LINK_NODE ) LN, list( h.QUALITY ) LQ
from NODES n
join ROUTE_HISTORY h on n.NODE=h.NODE
where n.NODE=5104
group by n.NODE, h.ROUTE_UPDATED
order by h.ROUTE_UPDATED desc

Are the LISTS guaranteed to be in matching order? So each entry of each comma-delimited list is pulled from the same row as the corresponding entry in the other lists?

--
Daniel
  • [firebird-support] Mu... 'Daniel Miller' dmil...@amfes.com [firebird-support]

Reply via email to