Re: [GENERAL] Trigger function cannot reference field name with capital letter

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? On Thursday,

Re: [GENERAL] Trigger function cannot reference field name with capital letter

Hi 2014-08-14 8:10 GMT+02:00 Patrick Dung patrick_...@yahoo.com.hk: 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.

Re: [GENERAL] Trigger function cannot reference field name with capital letter

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

Re: [GENERAL] Trigger function cannot reference field name with capital letter

On 14 August 2014 08:10, Patrick Dung patrick_...@yahoo.com.hk 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.

[GENERAL] Trigger function cannot reference field name with capital letter

Hello PGSQL users, I have a field called postTimestamp. The trigger function could not reference it. When I change my field to post_timestamp. I can reference it from the tigger function. Version is 9.3.5. Any comment? 2014-08-14 00:23:32.717 HKT ERROR:  post new has no field posttimestamp

Re: [GENERAL] Trigger function cannot reference field name with capital letter

On 08/13/2014 08:52 PM, Patrick Dung wrote: Hello PGSQL users, I have a field called postTimestamp. The trigger function could not reference it. When I change my field to post_timestamp. I can reference it from the tigger function. Version is 9.3.5. Any comment? 2014-08-14 00:23:32.717 HKT

Re: [GENERAL] Trigger function cannot reference field name with capital letter

On 8/13/2014 8:52 PM, Patrick Dung wrote: I have a field called postTimestamp. The trigger function could not reference it. When I change my field to post_timestamp. I can reference it from the tigger function. Version is 9.3.5. Any comment? 2014-08-14 00:23:32.717 HKT ERROR: post new has

Re: [GENERAL] Trigger function cannot reference field name with capital letter

On 8/13/2014 9:13 PM, John R Pierce wrote: SELECT * from tbl1 where new.postTimestamp' timestamp '2014-01-01 00:00:00' oops. SELECT * from tbl1 where new.postTimestamp timestamp '2014-01-01 00:00:00' I meant. I should proof what I write, hah! -- john r pierce