Re: Help with a very newbie question...

I think that sql-functions may serve as parametrized views for you...

http://www.postgresql.org/docs/8.0/static/xfunc-sql.html

Cristian Prieto wrote:

> I want to create a view or a sp which returns NULL if nothing is found
> and a recordset if the user is found
>
> I wrote something like:
>
> CREATE sp_getuser(name, pass) RETURNS record AS
> $body$
> DECLARE
>     retval RECORD;
> BEGIN
>     SELECT INTO retval * FROM Users WHERE userid=name AND passwd=pass;
>     IF NOT FOUND THEN
>         RETURN NULL;
>     ELSE
>         RETURN retval;
> END;
> $body$
> LANGUAGE plpgsql;
>
> What is wrong with that function? I guess I could create it as a View
> but I don't know how to pass parameters in a view, somebody could help
> me with this?
>
> Thanks a lot!