Kevin N

I have two tables of equal length that I want to join together row by row:

Table 1

Number|

-----------|

1 |

2 |

3 |

______|

Table 2

Letter|

--------|

a |

b |

c |

-------|

result

Letter | Number |

---------|--------------|

a | 1 |

etc.

A JOIN statement in the query would require something to JOIN ON to prevent getting all combinations, right? (a,1; a,2; a,3; b,1;etc). The only thing I can think of is to imbed a sequence generation inline and join on that:

SELECT Letter, i++ AS count1 from Table 1 JOIN Number, j++ AS count2 FROM Table2 ON count1=count2;

However, I don't think PosgreSQQL(or maybe even any database) can do something like than, can they?

I have a PostgreSQL database with a table called data. The table has two columns, d_timestamp and d_temp. Imagine the following data:

d_timestamp | d_temp|

-----------------|----------|

12:00AM | 70 |

4:00 AM | 70 |

8:00 AM | 70 |

4:00 PM | 74 |

8:00 PM | 73 |

I want to integrate the temperature to give me degree-days.So I want °*D=∫T*dt or ∑(T*Δt). If I had data reliably at every single 4 hour interval, Δt would be constant and I could do Δt * ∑T, or SELECT sum(d_temp/6) AS degree_days FROM data. The fact that I'm missing a few points means I have to look at the previous timestamp to calculate an interval.

The only way I can think of to accomplish this is to select the d_timestamp column ordered ascending, throw away the last entry and join it to the data with the first entry removed. Unfortunately, I don't know how to discard the first and last entries of a query.

I want the following result:

d_timestamp | d_temp| timestamp2|

-----------------|----------|---------------|

4:00 AM | 70 | 12:00 AM |

8:00 AM | 70 | 4:00 AM |

4:00 PM | 74 |8:00 AM |

8:00 PM | 73 |4:00 PM |

then I can SELECT sum(d_temp*(d_timestamp - timestamp2)) from (SubSelect TBD)

Any ideas?

I've seen some references to d-amyl alcohol and d-amyl acetate. I know n-amyl (1-pentanol) and iso-amyl (3-methyl-1-butanol), but I have no idea about d-amyl. Is it a mixture of optically active isomers (D vs. L)? Or is it maybe another name for 2-methyl-1-butanol (Active Amyl Alcohol)? Please let me know your source too...chemistry textbook, chemical catalog, etc.

http://gallery.beakerboy.com/main.php?g2_view=core...

I found this guy right after I almost stuck my hand in a Black Widow's web. It's about the same size and shape, but completely different coloration.

I know the following glucose disaccharides:

Maltose has an α 1→4 bond

Cellobiose has a β 1→4 bond

Trehalose has an α 1→1 bond

Is there a name for a glucose disaccharide with an α 1→6 bond?

Taking advantage of holiday sales I purchased an HDTV and just hooked up a standard coaxial cable to the TV. I do not have a cable box. I was flipping through the channels and realized I have a lot more channels than my analog tv (ESPNHD for example). A friend tells me that in order to truely see the picture in HD I NEED and HDMI cable.

My question is, is this true and more importantly, why? The signal is already coming to my house via coax cable so the cabling itself can't degrade the signal. The signal is digital, so it's not like there's any analog interference to worry about. I'd doubt the TV manufacturer would program in a technique to take a digital signal and display it at a poorer resolution just because it's coming through the "incorrect port".

Thanks.