On Tue, Aug 16, 2005 at 12:53:51 -0700,
The One <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a table with one encrypted column.
> How can I do a select statement such that it will select all columns from the
> table and at the same time will decrypt it too?
You want to explicitly list all of the column names in the select list, except
for the encrypted column for which you should call the decryption function.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
