use unnest instead of generate_series to get the current path

[davecramer]

[vlsi]

Is this still relevant?

I guess generate_series should be removed at least from "lookup type by name", see https://github.com/pgjdbc/pgjdbc/pull/3244