Hi Gibson,you need to add into and add a variable assuming your using plpgsql.
create or replace function function_name() returns user as'
begin
declare rec user;
select into rec * from user;
return rec;
end;
'language ' plpgsql';
This should work, I had the same problem the other day.
Hi,
I'm running postgreSQL 8.1 (with pgAdmin III included) on a Windows 2003 Small Business server. I would like to setup postgreSQL so that it would do some automated tasks in the database I'm using, so I decided to install pgAgent. I have followed the instructions on
http://www.pgadmin.org/docs/
Hi,
I've got pgAdmin III installed (included in postgresql 8.1). I'm running the postgreSQL server on Windows 2003 Small Business Server and would like to know where the upgrade wizzard is.
Does anyone know where to find it?
Cheers,Ben
