-- Name: collected_date_min; Type: VIEW; Schema: public; Owner: -

--

--

-- Name: collected_date_min; Type: ACL; Schema: public; Owner: -

--

--

-- Name: collected_date_min; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW collected_date_min AS

 SELECT analytical_stem."dateCollected"

   FROM analytical_stem

  WHERE (analytical_stem."dateCollected" IS NOT NULL)

  ORDER BY analytical_stem."dateCollected"

 LIMIT 1;

--

-- Name: collected_date_min; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE collected_date_min FROM PUBLIC;

REVOKE ALL ON TABLE collected_date_min FROM bien;

GRANT ALL ON TABLE collected_date_min TO bien;

GRANT SELECT ON TABLE collected_date_min TO bien_read;

GRANT SELECT ON TABLE collected_date_min TO public_;

--