KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to get this plpgsql function to work: CREATE OR REPLACE FUNCTION outofdate(actualdate varchar) RETURNS TABLE(designacion varchar(255),timebeingrotten varchar(255)) AS $BODY$ SELECT designacao, actualdate - prazo FROM alimento WHERE prazo < actualdate; $BODY$ LANGUAGE 'plpgsql' volatile; SELECT * From outofdate('12/12/2012'); It keeps giving me an error on line 2 - table .. ERROR: syntax error at or near "TABLE" LINE 2: RETURNS TABLE(designacion varchar(255),timebeingrotten varch... ^ *** Error ** * ERROR: syntax error at or near "TABLE" SQL state: 42601 Character: 67
Tags (comma-separated)
Save Edits
Cancel