Pavel Stehule wrote:
If I did the following:
SELECT * FROM "Users";
I get:
userid | passwd
----------+--------
cristian | hola
AND I execute:
SELECT getuser('cristian', 'hola');
I get:
getuser
-----------------
(cristian,hola)
There are two posibilities
SELECT getuser('cristian','hola');
SELECT * FROM getuser('cristian','hola') AS (userid varchar, passwd
varchar);
Or, define your function as ... RETURNS SETOF Users
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
