[SQL] Generating Rows from a date and a duration

2010-09-03 Thread Tim Schumacher
Hi List, I'm kinda stuck situation, I have a timestamp which resambles a startdate and a duration in days and I want to bloat this, so I have a row for every day beginning from the startdate. I have created an example bellow, maybe I'm doing it on the wrong angle and you can come up with some bett

[SQL] procedure help between databases

2010-09-03 Thread Daniel Sobey
Hello list, I need some help in writing a trigger / procedure. I have two databases, one for last.fm and one for musicbrainz. What I would like to do is when i submit a song into last.fm, connect to the musicbrainz and get an id for the song. Both are using postgres and i can use a db link to qu