[SQL] double linked list

2003-01-28 Thread Juergen
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

Re: [SQL] double linked list

2003-02-01 Thread Juergen
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

Re: [SQL] How to Get Timestamp From SECONDS?

2001-09-17 Thread Hans-Juergen Schoenig
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