Re: Query with left join?

2009-09-15 Thread Daniel Roseman
On Sep 15, 6:22 am, tom wrote: > Hi Daniel, > > i don't want to presentate the data. i want to produce graphs with > this data. so it's not a presentation problem. i know that i can use > python to get the data in correct order and style, but it's a huge > amount of data and python would be very

Re: Query with left join?

2009-09-14 Thread tom
Hi Daniel, i don't want to presentate the data. i want to produce graphs with this data. so it's not a presentation problem. i know that i can use python to get the data in correct order and style, but it's a huge amount of data and python would be very slow for that. so it's better when the data

Re: Query with left join?

2009-09-13 Thread Daniel Roseman
On 2009/9/13, tom wrote: > > I have a model to save measurement data. Every datarow has a > identifier(CharField) and a value(FloatField) and a entry(ForeignKey). > For example: > > Entry Identifier value > 1s1 100 > 1d1 180 > 1q5 300 > 2

Re: Query with left join?

2009-09-12 Thread Joshua Russo
On Sat, Sep 12, 2009 at 8:55 PM, Daniel Roseman wrote: > > On Sep 12, 9:53 pm, tom wrote: > > Hi, > > > > i want to produce a left-join query with the django orm. Can anybody > > help howto do the following query? > > > > SELECT S.value, D.value from data as S left join data as D on > > S.entry_i

Re: Query with left join?

2009-09-12 Thread Daniel Roseman
On Sep 12, 9:53 pm, tom wrote: > Hi, > > i want to produce a left-join query with the django orm. Can anybody > help howto do the following query? > > SELECT S.value, D.value from data as S left join data as D on > S.entry_id=D.entry_id; > > Cheers tom What's the point of this query? What are yo

Query with left join?

2009-09-12 Thread tom
Hi, i want to produce a left-join query with the django orm. Can anybody help howto do the following query? SELECT S.value, D.value from data as S left join data as D on S.entry_id=D.entry_id; Cheers tom --~--~-~--~~~---~--~~ You received this message because y