<snip>
There's an example in the manuals - chapter "7.2.1.4. Table Functions"
SELECT * FROM dblink('dbname=mydb', 'select proname, prosrc from pg_proc') AS t1(proname name, prosrc text) WHERE proname LIKE 'bytea%';
So basically, you need to supply the type definitions in your SELECT if you aren't going to supply it in the function definition.
ok I tried to rewrite as follows but I get an error that says "a column definition list is required fro functions returning record
Because you didn't supply the type definitions in your SELECT...
...here is my function and call for it now CREATE OR REPLACE FUNCTION "public"."loginbyindidgettest" (integer) RETURNS SETOF "pg_catalog"."record" AS'
select * from loginbyindidgettest(43650);
This needs to be something like:
SELECT * FROM loginbyindidgettest(43650) AS myres(a int, b text, c date, ...)
Obviously, the types need to match the results of your function. -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
