Re: Trigger function cannot reference field name with capital letter

[Patrick Dung <patrick_dkt@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general