From: | Sigurdur Helgason <shelgason(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | How to dynamically call a column in plpgsql |
Date: | 2002-10-28 08:30:10 |
Message-ID: | 20021028083010.96614.qmail@web41009.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi!
I am trying to fetch a value from a column, where the
columnname is a value in another column.
See below ..
table constraint_1 (
...
cons_col VARCHAR(15) NOT NULL,
...
)
Then in the trigger (written in plpgsql) I want to
fetch the appropriate column from the NEW record.
--- trigger --
bla bla bla...
select cons_col from constraint_1 where bla = bla ...
-- the_val := NEW.cons_col;
bla. bla .bla.
return NEW;
bla bla bla..
----
Well I have tried a couple different things .. none
seem to work. I know that this is possible if the
trigger is written in C .. but it might be nice to
know how to do this in plpgsql.
Anyone out there that knows how to do this?
_____________________________________________________
Gratis e-mail resten av livet på www.yahoo.se/mail
Busenkelt!
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - Design & Print | 2002-10-28 12:48:33 | Re: How to dynamically call a column in plpgsql |
Previous Message | Josh Berkus | 2002-10-28 01:13:30 | Re: how to create secondary key!! |