Re: Extending PostGreSQL/PostGIS with an abstract data type.

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: donia zheni <zheni_donia(at)yahoo(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Extending PostGreSQL/PostGIS with an abstract data type.
Date: 2010-04-08 12:11:10
Message-ID: 4BBDC7DE.6080603@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

donia zheni wrote:

> And if it's defined with "typedef", must all operations be defined also
> in C or can some functions be defined with plpgsql?

If you want a new data type that's only accessible using functions and
operators defined to operate on it, you must write it in C.

If you wanted to use PL/PgSQL to implement some operators, you'd have to
expose innards of the data type at the SQL level. Since you explicitly
do not want to do this, you cannot use PL/PgSQL.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ognjen Blagojevic 2010-04-08 13:14:05 [offtopic] How do you name a table...
Previous Message Michał Pawlikowski 2010-04-08 11:58:11 Re: Grant column level permissions