[SQL] how to do a select * and decrypt a column at the same time?

[The One]

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?__Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 

Re: [SQL] how to do a select * and decrypt a column at the same

[Scott Marlowe]

On Tue, 2005-08-16 at 14:53, The One 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?

A view should be able to do that...

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] how to do a select * and decrypt a column at the same time?

[Bruno Wolff III]

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