I'm just stepping into the wonderfull world of postgresql 8.0 on a windows platform, and I'm already confused. My initial impression was that it had stored procedures or equivalent with user-functions. I created a function as follows:
CREATE FUNCTION "public"."fnallparts" () RETURNS SETOF "public"."tblPart" AS
SELECT * FROM "public"."tblPart";
LANGUAGE 'sql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
now the only way to call this is like so:
select * from fnallparts;
and then it returns a bunch of data separated with commas. Is there anyway to return data in a column (table) format like a regular query like you can in mssql?