Postgres Pro
Downloads
Home   >   mailing lists

Re: Hierarchical Query Question (PHP) - Mailing list pgsql-general

From David Blomstrom
Subject Re: Hierarchical Query Question (PHP)
Date
Msg-id CAA54Z0gDKOC3bNNHJXY5Mm8aWCbPV6M8qOUNY_CnPGzNiKWL3w@mail.gmail.com
Whole thread Raw
In response to Re: Hierarchical Query Question (PHP)  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Hierarchical Query Question (PHP)  (David Blomstrom <david.blomstrom@gmail.com>)
List pgsql-general
Tree view
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;


pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Hierarchical Query Question (PHP)
Next
From: David Blomstrom
Date:
Subject: Re: Hierarchical Query Question (PHP)