As strange as this may sound, I had to do a cross database query at my
last job. It involved moving information from our e-commerce database
into the accounting system database. While there may have been another
way of handling it, this did allow me to handle the move solely within
MSSQL and not
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
>
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 sel
