Closed benedeki closed 4 months ago
Changing it rather to Question
instead of Spike
.
After some impromptu conversation in the office we figured that the best slution, at least for now is:
OUT id_checkpoint UUID,
OUT checkpoint_name TEXT,
OUT measure_name TEXT,
OUT measure_columns TEXT[],
OUT measurement_value JSONB,
OUT checkpoint_time TIMESTAMP WITH TIME ZONE
always ordered by id_checkpoint
first to ensure, that measurements from the same checkpoint are after each other.
Background
As each counterpoint has (potentially) multiple measurements, if multiple checkpoints are to be returned from a function what would be the best way to return them.
Questions To Answer
Options
Desired Outcome
The method of choice to return these data.
Additional Info/Resources [Optional]