René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Itemized columns in function not working ","articleBody":"### Version\n\n1.18.0\n\n### What happened?\n\nWhen not using * (A_Star) and itemizing columns, functions fail to generate.\n\n### Relevant log output\n\n```shell\nsqlc generate failed.\r\n\r\n# package db\r\nquery.sql:15:8: column \"id\" does not exist\n```\n\n\n### Database schema\n\n```sql\ncreate table blog (\r\n    id serial primary key,\r\n    name text not null\r\n\r\n);\r\n\r\ncreate function test_select_blog(in p_id int)\r\n    returns table (id int, name text) AS $$\r\nBEGIN RETURN QUERY\r\n    select id, name from blog where id = p_id;\r\nEND;\r\n$$ language plpgsql;\n```\n\n\n### SQL queries\n\n```sql\n-- name: TestFuncSelectBlog :many\r\nselect id, name from test_select_blog($1);\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/122897d98d937d01051777c6ab253ccb16e5c20d513c03c4e1049bf36349f4f5\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-28T15:57:26.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/2386/sqlc/issues/2386"}