Re: field names for new in trigger function

From: Mark Kelly <pgsql(at)wastedtimes(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: field names for new in trigger function
Date: 2010-05-07 18:02:14
Message-ID: 201005071902.14694.pgsql@wastedtimes.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi.

On Monday 03 May 2010 at 18:03 Charles Holleran wrote:

[snip]

> Can't change the column names now. What is correct syntax to get the
> "sourceDate" field of the NEW object?
>
> Any insight appreciated.

I don't know about in code, but in straight SQL column names with upper-case
need to be quoted. Might be worth a try.

Cheers,

Mark

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Didier Gasser-Morlay 2010-05-08 15:54:21 Re: field names for new in trigger function
Previous Message Tom Lane 2010-05-07 15:54:25 Re: ERROR: XX001 (Critical and Urgent)