Re: [GENERAL] Case sensitivity

2001-08-14 Thread Digital Wokan
Very good book. I have the .pdf file of it from before they took it off the site. John Clark Naldoza y Lopez wrote: Hello Scott, PostgreSQL also supports regular expressions, _VERY_ useful..;-) ~* regular expression, case-insensitive..;-) Try to get a copy of Bruce's book

Re: [GENERAL] Encrypting columns, security

2001-08-09 Thread Digital Wokan
If you were to instead run your inserts, updates, and selects through a procedure, you could achieve the same affect. You could have the select require the decode key be passed. From the method you're asking about, the whole point of encrypting the column would be undone by *ANYBODY* doing a