[Pdx-pm] (OT) SQL style question

[David Wheeler]

On Jan 13, 2005, at 4:12 PM, Kevin Long wrote:

> I have use _DOT_ in the past. I would also consider other human 
> readable
> alternatives like _CONTAINS_ which conveys more meaning and avoids the
> difficulty of seeing a difference between A_VERY_LONG__THING and
> A_VERY_LONG_THING

What if you have a column named "contains"?

Recall that SQL entity names are case-insensitive unless you use 
quotation marks. And if you're going to use quotation marks, you might 
as well use a punctuation character to do the work (. or - or * or or + 
or something--or even -> :-)).

Regards,

David
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2369 bytes
Desc: not available
Url : http://mail.pm.org/pipermail/pdx-pm-list/attachments/20050113/96d98d00/smime-0001.bin