Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Geo-x <x-lalande(at)cc-lacq(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)
Date: 2012-05-04 13:12:14
Message-ID: CAHyXU0xT73NgM3TG-5Co82TFOJaFWyZ=KuLibwQq6ckuVVH=Jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 4, 2012 at 8:04 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> Hello
>
> this can help http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Iteration_over_RECORD_variable_inside_trigger

hstore has replaced information schema method for me when doing these
type of things:

see: http://archives.postgresql.org/pgsql-general/2012-02/msg00251.php

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent de Phily 2012-05-04 13:55:48 Streaming replication: sequences on slave seemingly ahead of sequences on master
Previous Message Pavel Stehule 2012-05-04 13:04:33 Re: Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)