user defined data type

From: vikas vashista <er(dot)vikasvashista(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: user defined data type
Date: 2009-10-22 13:10:44
Message-ID: 167ed6110910220610m73893d6cx38d92f1aff8b0681@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi

my aim is to put a the UPDATE operation result showing which field updated
with having details of field name, old value & new vale.
i had written the trigger for it, and that working fine.
But for a very large database i want to use array for dynamic length.
I want to create user defined data type and want to used in array type for
input the output of my trigger of UPDATE operation.

how can i built user defined data type?
how can i used my user defined data type for array?

with regrds
vikas

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nathaniel Trellice 2009-10-22 14:40:22 Asynchronous commands
Previous Message Josh Kupershmidt 2009-10-21 22:06:44 Re: Does pgsql database (file) size increases automatically as we put data?