X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A160E52A2F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Aug 2005 16:53:55 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 84446-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Aug 2005 19:53:51 +0000 (GMT)
Received: from web33911.mail.mud.yahoo.com (web33911.mail.mud.yahoo.com
	[66.163.178.75])
	by svr1.postgresql.org (Postfix) with SMTP id 2FC0152A1E
	for <pgsql-sql@postgresql.org>; Tue, 16 Aug 2005 16:53:50 -0300 (ADT)
Received: (qmail 634 invoked by uid 60001); 16 Aug 2005 19:53:51 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=DFB6WNwkhtt4T8G5cQZwop94+GlJDr/KOmZKMKkxAOmr8ePFFUr2lah5Ph/QkXrb21B6z+OWFsWBrCPlznr2dixqlLlryEFcUXqWblif1aDqaEGUjVdN5DWpGrAZ+PeF1AfeYVG4Vd5987S40aA+hbTnAwmsWc23oMIgPAAKvY8=
	;
Message-ID: <20050816195351.632.qmail@web33911.mail.mud.yahoo.com>
Received: from [68.209.250.7] by web33911.mail.mud.yahoo.com via HTTP;
	Tue, 16 Aug 2005 12:53:51 PDT
Date: Tue, 16 Aug 2005 12:53:51 -0700 (PDT)
From: The One <i51359@yahoo.com>
Subject: how to do a select * and decrypt a column at the same time?
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-587561543-1124222031=:94353"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.079 required=5 tests=[AWL=-0.107,
	DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516, HTML_10_20=0.295,
	HTML_MESSAGE=0.001]
X-Spam-Level: *
X-Archive-Number: 200508/116
X-Sequence-Number: 22344

--0-587561543-1124222031=:94353
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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 
--0-587561543-1124222031=:94353
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>Hello,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I have a table with one encrypted column.</DIV>
<DIV>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?</DIV><p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-587561543-1124222031=:94353--