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

Re: field names for new in trigger function

From: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
To: scorpdaddy(at)hotmail(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: field names for new in trigger function
Date: 2010-05-08 15:54:21
Message-ID: AANLkTilmiIkSWPtiI5lFW7tRtE2VYw9z_-g90jkd8Y3v@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Have you tried quoting the field name, you're using a mixed case field name
and AFAIK, if you don't quote PostgresSQL looks for the field in lowercase,
only quoting preserves the case as you want it.

Again AFAIK

Didier

pgsql-novice by date

Next:From: Carel CombrinkDate: 2010-05-10 10:12:17
Subject: C-Function: Returning Rows
Previous:From: Mark KellyDate: 2010-05-07 18:02:14
Subject: Re: field names for new in trigger function

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