Search Postgresql Archives

Re: Questions on user defined data types

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Apr 24, 2018 at 4:53 AM, a <372660931@xxxxxx> wrote:
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. 


What you describe seems doable, at least to some ​degree.  See the documentation for:

​CREATE TYPE
CREATE TABLE
CREATE FUNCTION
GRANT
David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux