> Examples
> of real-life work that is using custom types right now would be
> helpful too. Once we have a semi-working API, you could make
> some tests. More tests are always good. :)
Here's what I've been working toward:
CREATE TYPE ftp_site AS
(host "text",
userid "text",
"password" "text",
path "text");
CREATE TABLE custom_document_destination
(
customer_id serial NOT NULL,
archive_path text NOT NULL,
doc_site ftp_site NOT NULL,
route_site ftp_site NOT NULL,
);
The ftp_site structure would then be a parameter to a method along the
lines of ftp_transfer($site, $file). Pretty straightforward. I could
probably throw together a test case once the API is firm.