René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"postgres functions have empty Row structs","articleBody":"### Version\n\n1.18.0\n\n### What happened?\n\nFunctions created for Postgres are not generating fields for returned row structs. For example:\r\n```\r\ntype TestFuncSelectBlogRow struct {\r\n}\r\n```\r\n\r\nI suspect that I'm doing something wrong, but I can't seem to figure this out. Any help would be greatly appreciated. Thank you in advance. \n\n### Relevant log output\n\n```shell\nconst testFuncGetTime = `-- name: TestFuncGetTime :one\r\nselect  from test_fuct_get_time($1)\r\n`\r\n\r\ntype TestFuncGetTimeParams struct {\r\n\tTestFuctGetTime interface{} `json:\"testFuctGetTime\"`\r\n}\r\n\r\ntype TestFuncGetTimeRow struct {\r\n}\r\n\r\nfunc (q *Queries) TestFuncGetTime(ctx context.Context, arg TestFuncGetTimeParams) (TestFuncGetTimeRow, error) {\r\n\trow := q.db.QueryRow(ctx, testFuncGetTime, arg.TestFuctGetTime)\r\n\tvar i TestFuncGetTimeRow\r\n\terr := row.Scan()\r\n\treturn i, err\r\n}\r\n\r\nconst testFuncSelectBlog = `-- name: TestFuncSelectBlog :one\r\nselect  from test_func_select_blog($1)\r\n`\r\n\r\ntype TestFuncSelectBlogParams struct {\r\n\tTestFuncSelectBlog interface{} `json:\"testFuncSelectBlog\"`\r\n}\r\n\r\ntype TestFuncSelectBlogRow struct {\r\n}\r\n\r\nfunc (q *Queries) TestFuncSelectBlog(ctx context.Context, arg TestFuncSelectBlogParams) (TestFuncSelectBlogRow, error) {\r\n\trow := q.db.QueryRow(ctx, testFuncSelectBlog, arg.TestFuncSelectBlog)\r\n\tvar i TestFuncSelectBlogRow\r\n\terr := row.Scan()\r\n\treturn i, err\r\n}\r\n\r\nconst testFuncSelectString = `-- name: TestFuncSelectString :one\r\nselect  from test_func_select_string($1)\r\n`\r\n\r\ntype TestFuncSelectStringParams struct {\r\n\tTestFuncSelectString interface{} `json:\"testFuncSelectString\"`\r\n}\r\n\r\ntype TestFuncSelectStringRow struct {\r\n}\r\n\r\nfunc (q *Queries) TestFuncSelectString(ctx context.Context, arg TestFuncSelectStringParams) (TestFuncSelectStringRow, error) {\r\n\trow := q.db.QueryRow(ctx, testFuncSelectString, arg.TestFuncSelectString)\r\n\tvar i TestFuncSelectStringRow\r\n\terr := row.Scan()\r\n\treturn i, err\r\n}\n```\n\n\n### Database schema\n\n```sql\ncreate function test_func_get_time ()\r\n    returns timestamp AS $$\r\nBegin\r\n    return now();\r\nEnd;\r\n$$ language plpgsql;\r\n\r\ncreate function test_select_string (in p_string text)\r\n    returns text AS $$\r\nBegin\r\n    return p_string;\r\nEnd;\r\n$$ language plpgsql;\r\n\r\ncreate function test_select_blog(in p_id int)\r\n    returns table (id int, name text, created_at timestamp, updated_at timestamp) AS $$\r\nBEGIN RETURN QUERY\r\n    select id, name, created_at, updated_at from blog where id = p_id;\r\nEND;\r\n$$ language plpgsql;\n```\n\n\n### SQL queries\n\n```sql\n-- name: TestFuncGetTime :one\r\nselect * from test_fuct_get_time($1);\r\n\r\n-- name: TestFuncSelectString :one\r\nselect * from test_func_select_string($1);\r\n\r\n-- name: TestFuncSelectBlog :one\r\nselect * from test_func_select_blog($1);\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/f91c263ba2690afce4165f4febce483987995c3ba53e96a8f40bcd7e0af5fbc8\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/jwc-clinnection","@type":"Person","name":"jwc-clinnection"},"datePublished":"2023-06-24T17:18:37.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2364/sqlc/issues/2364"}