Postgres Pro
Downloads
Home   >   mailing lists

Re: field names for new in trigger function - Mailing list pgsql-novice

From Mark Kelly
Subject Re: field names for new in trigger function
Date
Msg-id 201005071902.14694.pgsql@wastedtimes.net
Whole thread Raw
In response to field names for new in trigger function  (Charles Holleran <scorpdaddy@hotmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Atif Jung
Date:
Subject: PREPARE statement
Next
From: Didier Gasser-Morlay
Date:
Subject: Re: field names for new in trigger function