troubleshooting Question

How do I return all columns in a postgres function?

Avatar of blue44
blue44Flag for United States of America asked on
PostgreSQL
4 Comments2 Solutions1107 ViewsLast Modified:
Hi,

I'm using Postgres 8.3 and wrote the below function to return all matching records.  When I try to  execute the function, I get the following error:

ERROR:  a column definition list is required for functions returning "record"

Any help would be greatly appreciated.

Thanks!
CREATE OR REPLACE FUNCTION getCustomer(IN name character varying(50))
  RETURNS setof record AS
$BODY$
SELECT * FROM Customer WHERE name LIKE '%'||$1||'%';
$BODY$
  LANGUAGE 'sql' VOLATILE
  COST 100;

Open in new window

ASKER CERTIFIED SOLUTION
joshguzman

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros