Re: [GENERAL] Hierarchical Query Question (PHP)

[David Blomstrom]

Yes, I guess it does make sense to keep a copy of your actions.

In the meantime, I now have two new tables with the following schema:

-- Table: public.taxon

-- DROP TABLE public.taxon;

CREATE TABLE public.taxon
(
  taxonid integer NOT NULL DEFAULT nextval('taxon_taxonid_seq'::regclass),
  descr text
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.taxon
  OWNER TO postgres;


* * * * *

-- Table: public.gz_life_mammals

-- DROP TABLE public.gz_life_mammals;

CREATE TABLE public.gz_life_mammals
(
  id integer NOT NULL DEFAULT nextval('gz_life_mammalsx_id_seq'::regclass),
  taxonid integer,
  parentid integer
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.gz_life_mammals
  OWNER TO postgres;