Hi All,
I would like to write a function that returns multiple rows and multiple
fields, something like this. I know the syntax is probably wrong, any helps
would be appreciated.
CREATE FUNCTION GetGuestbookMessages (int4) RETURNS SETOF VARCHAR AS
'
SELECT guestname, guestemail FROM GuestbookMessages WHERE UserId = $1
' LANGUAGE 'sql';
notice that I want to return more than one field and more than one record in
the above function. Thanks.
wooi.