From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | David Blomstrom <david(dot)blomstrom(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Hierarchical Query Question (PHP) |
Date: | 2015-10-30 23:00:09 |
Message-ID: | 5633F679.3070707@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/30/2015 04:55 PM, David Blomstrom wrote:
> The field descr would presumably hold the values I originally had in
> the field Taxon - e.g. the names of various taxons, like 'Mammalia'
> and 'Canis-lupus.' The field id is just a numerical key, and I already
> have the numerical values for parentid.
>
> But what am I supposed to put in the field taxonid?
Hm, you might want to take a step back. What does the parentid field
you already have represent. Is it you mysql version of the data. Does
it point to an id of a taxon from the version? If so you need to
redefine the taxon table to just integer, not serial and load that table
from you csv dump of mysql.
Otherwise I suspect you will need redo your parentids.
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2015-10-30 23:02:23 | Re: Hierarchical Query Question (PHP) |
Previous Message | David Blomstrom | 2015-10-30 22:55:10 | Re: Hierarchical Query Question (PHP) |