X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.225.181])
	by svr1.postgresql.org (Postfix) with ESMTP id C50CBCCD26
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 13:41:15 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new,
	port 10024) with ESMTP id 01656-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 13:41:33 +0000 (GMT)
Received: from mail.travelamericas.com (dsl231-059-037.sea1.dsl.speakeasy.net
	[216.231.59.37])
	by svr1.postgresql.org (Postfix) with SMTP id AC981CCCE3
	for <pgsql-sql@postgresql.org>; Fri, 18 Jul 2003 10:41:03 -0300 (ADT)
Received: (qmail 4226 invoked from network); 18 Jul 2003 13:41:36 -0000
Received: from unknown (HELO travelamericas.com) (127.0.0.1)
	by localhost with SMTP; 18 Jul 2003 13:41:36 -0000
Message-ID: <3F17F90F.5020403@travelamericas.com>
Date: Fri, 18 Jul 2003 06:41:35 -0700
From: Chris Travers <chris@travelamericas.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: How to determine the currently logged on username
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/253
X-Sequence-Number: 14367

Hi all;

I will be writing a stored proceedure that will allow a currently logged 
in user to change his/her password.  The function needs to be only able 
to change the password of the currently logged in user, so it will only 
take a varchar() argument and needs to look up the username of the 
currently logged in user.  How do I do this?  Any ideas?

Best Wishes,
Chris Travers