Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger function cannot reference field name with capital letter - Mailing list pgsql-general

From Patrick Dung
Subject Re: Trigger function cannot reference field name with capital letter
Date
Msg-id 1407996651.98969.YahooMailNeo@web193506.mail.sg3.yahoo.com
Whole thread Raw
In response to Re: Trigger function cannot reference field name with capital letter  (John R Pierce <pierce@hogranch.com>)
Responses Re: Trigger function cannot reference field name with capital letter  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Trigger function cannot reference field name with capital letter  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Trigger function cannot reference field name with capital letter  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Tree view
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, August 14, 2014 12:18 PM, John R Pierce <pierce@hogranch.com> wrote:


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                                      37N 122W
somewhere on the middle of the left coast




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



pgsql-general by date:

Previous
From: Andrew Bartley
Date:
Subject: Re: Pass where clause to a function
Next
From: John R Pierce
Date:
Subject: Re: Pass where clause to a function