Strange things....

MatsP · Post by **MatsP** » 27 Nov 2007, 22:00

http://www.planetcatfish.com/catelog/sp ... ies_id=733

There is bits in there about "Clown pleco" and "Panoqulus".

I didn't want to just edit it, because I'd like you to understand what's happening - is it just a bad edit, or some other problem here?

--
Mats

Post by **Marc van Arc** » 27 Nov 2007, 22:19

I've already sent an edit, deleting the pleco stuff and adding the author and year.

YouTube · Post by **Jools** » 27 Nov 2007, 22:46

Aye, that's an issue for me. I "re-used" a species ID number for the new species from a species I previously combined into . At present, my code isn't clever enough to re-allocate common names or my cats keepers.

I will change it manually now.

Jools

MatsP · Post by **MatsP** » 27 Nov 2007, 22:53

Not that it really matters to me, but why "reuse" a number? It's not like a mediumint is ever going to "run out of number", right? I guess it will be at least a few million, and even if every single species of catfish in the world got described tomorrow, we'd probably still only have a few thousands...

--
Mats

YouTube · Post by **Jools** » 27 Nov 2007, 23:02

MatsP wrote:Not that it really matters to me, but why "reuse" a number? It's not like a mediumint is ever going to "run out of number", right? I guess it will be at least a few million, and even if every single species of catfish in the world got described tomorrow, we'd probably still only have a few thousands...

Good question, if I have no blanks or "holes" in the sequence numbers, then the number I add for a new species is also the total number of species.

That tells me, for example, tonight we passed 1900 species.

Jools

MatsP · Post by **MatsP** » 28 Nov 2007, 10:01

Yeah, but you could easily use "count(*) from species_table" to tell you that - yes it's a tiny bit less efficient, but if you don't do it every time someone reads a post, I guess it won't make much difference.

--
Mats