relations between the first seller 'A' and the last
buyer 'B'.
the result should be
S B
- -
A B
B C
C D
D E
Currently I fumbling around with self joins but haven't figured out
yet.
Any suggestions
Many tanks in advance
Cheers
Juergen
---(end of
given end point
cheers
Juergen
[EMAIL PROTECTED] (--CELKO--) wrote in message
news:<[EMAIL PROTECTED]>...
> >> I've got a table called 'link_t' containing a collection of seller
> -
> buyer relations between two parties. <<
>
> That is not a rea
Try it with something like that:
mydata=# SELECT '1-1-2001'::timestamp + '200 seconds'::interval;
?column?
2001-01-01 00:03:20+01
(1 row)
epoch + seconds = desired timestamp.
Hans
---(end of broadcast)---
T