我想知道是否可以在postgresql 8.4中使用oracle风格的面向对象编程。 我已经安装了orafce。 当我试图创build一个像这样的对象:
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
像这样的东西?
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);