Re: PL/PGSQL - character varying as function argument

On 26/09/2008 14:35, Chris Baechle wrote:

> CREATE OR REPLACE FUNCTION user_checkCredentials(character varying)
> RETURNS character varying AS
> $BODY$
> DECLARE
> username ALIAS FOR $1;
> permission record;
> BEGIN
> select into permission permtype from users;
> RETURN permission.permtype;

You're missing the "where" clause from the query - it should be:

select into permission permtype from users
where uid = username;

...where uid is the name of the appropriate column in your users table.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------