postgresql中的Oracle样式编程

Question

我想知道PostgreSQL8.4中是否可以使用oracle风格的面向对象编程。我安装了orafce。当我试图创建这样一个对象时：

CREATE TYPE addr_obj_typ AS OBJECT (
    street          VARCHAR2(30),
    city            VARCHAR2(20),
    state           CHAR(2),
    zip             NUMBER(5));

我得到了一个错误：

ERROR:  syntax error at or near "object"
LINE 1: create type addr_obj_typ as object

Answer 1

像这样吗？

CREATE DOMAIN zipcode AS 
    INT CHECK(VALUE < 99999)
;

CREATE TYPE addr_obj_typ AS  (
    street  VARCHAR(30),
    city    VARCHAR(20),
    state   CHAR(2),
    zip     zipcode
);

SELECT
    CAST(('a','b','c','90210') AS addr_obj_typ);