Skip site navigation (1) Skip section navigation (2)

Create generic Function definition in Perl

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Create generic Function definition in Perl
Date: 2009-08-27 10:22:17
Message-ID: c11950270908270322l68ec34fbp38ad8d78348d0a6d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I have written function and trigger for my table in Perl. I have many tables
in my database with the variable number of columns. I want to create trigger
for insert, update and delete operations for each tables but want to use the
same function for all the triggers. This could only be possible if I don't
hard code the column names. I referred Chapter:40.6 but couldn't find any
field that returns the number of columns along with their names could be
retrieved using Perl function.

In Perl, could any one tell me if there is any way to get the total number
of columns available in table(with their names) for which trigger has
invoked?

Thanks,
Jignesh

pgsql-novice by date

Next:From: Ruzsinszky AttilaDate: 2009-08-27 10:39:13
Subject: Simple like filter
Previous:From: Jignesh ShahDate: 2009-08-27 10:14:31
Subject: Re: Perl trigger not working

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group