Re: Hierarchical Query Question (PHP)
| От | David Blomstrom |
|---|---|
| Тема | Re: Hierarchical Query Question (PHP) |
| Дата | |
| Msg-id | CAA54Z0ihseOgxH13AiDjK6RJbN32ni+K3VAH4wpeXTVVXc8fWw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Hierarchical Query Question (PHP) (Andy Colson <andy@squeakycode.net>) |
| Ответы |
Re: Hierarchical Query Question (PHP)
Re: Hierarchical Query Question (PHP) Re: Hierarchical Query Question (PHP) Re: Hierarchical Query Question (PHP) |
| Список | pgsql-general |
Just so I understand what's going on, I can create a lookup table by pasting this code...
create table taxon (
taxonid serial,
descr text
);
create table gz_life_mammals (
id serial,
taxonid integer, -- use the lookup table
parentid integer -- use the lookup table
);
taxonid serial,
descr text
);
create table gz_life_mammals (
id serial,
taxonid integer, -- use the lookup table
parentid integer -- use the lookup table
);
...into pgAdmin III, right? (I can't use the shell/terminal at the moment, and it will be at least a few weeks before I can get it fixed.) And this script will create TWO tables - gz_life_mammals and a matching "lookup table"?
В списке pgsql-general по дате отправления: