Re: Trigger function cannot reference field name with capital letter
| От | Patrick Dung |
|---|---|
| Тема | Re: Trigger function cannot reference field name with capital letter |
| Дата | |
| Msg-id | 1407996651.98969.YahooMailNeo@web193506.mail.sg3.yahoo.com обсуждение исходный текст |
| Ответ на | Re: Trigger function cannot reference field name with capital letter (John R Pierce <pierce@hogranch.com>) |
| Ответы |
Re: Trigger function cannot reference field name with
capital letter
Re: Trigger function cannot reference field name with capital letter Re: Trigger function cannot reference field name with capital letter |
| Список | pgsql-general |
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
>
> 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 по дате отправления: