Comments by Member 10104822

Member 10104822 28-Feb-18 8:09am View

You are a genius sir.

Thank you very much!

Member 10104822 28-Feb-18 7:26am View

That's the thing. I need to be able to insert one row at a time into the target table and query that table before each new row is inserted.

That is the crux of the problem really

Member 10104822 28-Feb-18 7:00am View

unfortunately this does not work. I get the error;

Invalid operation: operator does not exist: character varying =@ character varying;

Are you using variables? Redshift does not support variables unfortunately

Member 10104822 28-Feb-18 6:24am View

It is.empty

Member 10104822 28-Feb-18 6:09am View

It is

Member 10104822 28-Feb-18 5:53am View

This scenario can't occur. There will always be on overlap.
it would go from
A1 -> A2 -> B2 or vice versa.
You'll always have an overlap.

Member 10104822 28-Feb-18 4:46am View

Correct

Member 10104822 27-Feb-18 14:40pm View

This is not a contrived exercise. The data supplied is just analogous dummy data. All I'm saying is that for what i need this for, if there are conflicts then i dont need to add some additional logic to determine the correct value. It can be ordered first but for simplicities sake its not needed

Comments by Member 10104822 (Top 8 by date)