Questions on user defined data types

From: a <372660931(at)qq(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Questions on user defined data types
Date: 2018-04-24 11:53:01
Message-ID: tencent_34A63D8D2D86225269E1A816@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there:

I want to ask the if I could define an object like type in postgresql, it may be better to illustrate with actual examples.

Background information:

1, I would like to pack group of data into 1 entry of in a table.

2, The table consist some financial product information including names, public data and etc.

3, Each product need to be valued, and the packed entry contains all the assumptions (interest rate, etc.) to perform valuation calculation of the products.

Furthermore, for company management purpose, the packed data would have the following properties:

1, Elements of the entry can be easily queried, using SQL;

2, Change of element value is not allowed by simple update, only using pre-complied "methods" functions can update them;

3, Changes using methods functions would be recorded into a specified sub-object called "LOG", which record down update information including update times and etc.

I am asking if this could be realized and if yes, how should I do it.

Thank you so much ~~

Shore

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-04-24 12:20:32 Re: Questions on user defined data types
Previous Message Tony Shelver 2018-04-24 11:36:00 Re: Rationale for aversion to the central database?