Re: Trigger function cannot reference field name with capital letter

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk>, John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger function cannot reference field name with capital letter
Date: 2014-08-14 13:41:00
Message-ID: 53ECBC6C.20506@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/13/2014 11:10 PM, Patrick Dung wrote:
> Thanks all for the help.
>
> BTW, letter casing is just a preference.
> Some people liked to use all small caps, some liked to use all big caps.
> I sometimes found that mixed case is more meaningful for the filed (eg.
> serialnumber vs serialNumber)
>
> What is your preference or suggestion?

My preference is lower case with underscores between words. I stay away
from CamelCaps for the reasons Pavel mentioned. Probably the most
important thing is to be consistent in your style.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2014-08-14 13:47:29 Re: Pass where clause to a function
Previous Message dushy 2014-08-14 09:13:52 Re: Postgres 9.3 tuning advice