X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 4D7919FA159
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 21 May 2006 07:34:26 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 48407-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 21 May 2006 07:34:16 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.183])
	by postgresql.org (Postfix) with ESMTP id B94AB9FA131
	for <pgsql-sql@postgresql.org>; Sun, 21 May 2006 07:34:16 -0300 (ADT)
Received: from [84.157.69.121] (helo=lunix.schabi.de)
	by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis),
	id 0MKxQS-1FhlGI18Mf-0006of; Sun, 21 May 2006 12:34:14 +0200
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by lunix.schabi.de (Postfix) with ESMTP id EC5717B5A2;
	Sun, 21 May 2006 12:34:10 +0200 (CEST)
Message-ID: <44704222.5080807@logix-tt.com>
Date: Sun, 21 May 2006 12:34:10 +0200
From: Markus Schaber <schabi@logix-tt.com>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: de-DE, de, en-us, en
MIME-Version: 1.0
To: kijato <kijato@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: usernames of a group from SQL
References: <Pine.LNX.4.44.0605191304380.3491-100000@matrix.gatewaynet.com>
	<200605211004.30969.kijato@gmail.com>
In-Reply-To: <200605211004.30969.kijato@gmail.com>
X-Enigmail-Version: 0.93.0.0
Content-Type: text/plain; charset=ISO-8859-7
Content-Transfer-Encoding: 7bit
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:a9554655f07a4e401310f2acfb43f5bf
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/162
X-Sequence-Number: 25193

Hi, Kijato,

kijato schrieb:

> CREATE FUNCTION kodok.group_users(group_name "varchar")
> RETURNS SETOF "varchar" AS
> $BODY$
> SELECT pg_user.usename
> FROM pg_user, pg_group
> WHERE usesysid = any (pg_group.grolist) AND pg_group.groname=$1;
> $BODY$
> LANGUAGE 'sql' VOLATILE;

The pg_user.username column uses the PostgreSQL internal type "name"
which is used for identifiers like table and user names. The PostgreSQL
Documentation contains more about this.

I think you can cast it to varchar, like:

SELECT pg_user.username::varchar


HTH,
Markus