Besides the above,
I recall Flickr (you know the photo-sharing site) being able to extract
(kind of rough) polygons from exif-data of photos (containing lat/longs) .
Since often these photo's are tagged by city they could extract city
boundaries.
See this old posts I dug up quickly, I'm not sure
Aren't you grouping on IDt?
something like ? :
select t2.IDt,t2.ID,t2.Num,max(t2.version) from table1 as t1, tabl2 as t2
where t1.num=t2.num and t1.state!='new' group by t2.IDt
Cheers,
Geert-Jan
2010/7/26 Michael Stroh
> Hi everyone and thanks in advance for the help. I have a query that I'd
>
Am I correct in assuming that "Industries" can be seen as some sort of
"super contact-group" in your application?
If so, you could merge "Contact group" and "Industries" --> "Contact group"
Contact Groups
--
id
name
parent_id (FK)
type ("industry_level, "sub_level", "some_other_lev
As a side-note: letting a random user (such as your website visitor) wait
for a couple of seconds is usually not good practice, unless you have a very
good incentive for them to do so.
2010/4/16 Jørn Dahl-Stamnes
> On Friday 16 April 2010 11:39, Antonio PHP wrote:
> > This maybe a newbie questio
Perhaps you could give us a (generalized) description of your use-case, so
we can better grasp what you want to achieve, and how you want to use it.
i.e: since I can't imagine/ envison a real 'eucledian distance' over 96
dimensions I bet you're talking a generalized distance function over N
dimenio
Hi Jeffrey,
David already gave a lot of valid points.
Table-per-documenttype seems the way to go here.
As to the 'best' db-scheme for your task given your description you have to
ask yourself a couple of questions:
Please note that with a document-type I mean a type like book, html page,
etc.