René's URL Explorer Experiment


Title: sqlc.Narg does not work with enums · Issue #1683 · sqlc-dev/sqlc · GitHub

Open Graph Title: sqlc.Narg does not work with enums · Issue #1683 · sqlc-dev/sqlc

X Title: sqlc.Narg does not work with enums · Issue #1683 · sqlc-dev/sqlc

Description: Version 1.14.0 What happened? sqlc.narg is a great addition. Unfortunately, it does not seem to work for enum types. I would really like to be able to use nullable enums, as empty strings are invalid enums and throw an error. In the exam...

Open Graph Description: Version 1.14.0 What happened? sqlc.narg is a great addition. Unfortunately, it does not seem to work for enum types. I would really like to be able to use nullable enums, as empty strings are inval...

X Description: Version 1.14.0 What happened? sqlc.narg is a great addition. Unfortunately, it does not seem to work for enum types. I would really like to be able to use nullable enums, as empty strings are inval...

Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/1683

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc.Narg does not work with enums","articleBody":"### Version\r\n\r\n1.14.0\r\n\r\n### What happened?\r\n\r\nsqlc.narg is a great addition. Unfortunately, it does not seem to work for enum types. I would really like to be able to use nullable enums, as empty strings are invalid enums and throw an error.\r\n\r\nIn the example provided, it would be great if the method definition used `*Colors` to make it nullable:\r\n```golang\r\nfunc (q *Queries) GetBoxes(ctx context.Context, color *Colors) ([]Box, error) {\r\n```\r\n\r\nThe actual method does not accept a nullable argument.\r\n```golang\r\nfunc (q *Queries) GetBoxes(ctx context.Context, color Colors) ([]Box, error) {\r\n```\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TYPE colors AS ENUM (\r\n    'red',\r\n    'blue',\r\n    'green'\r\n);\r\n\r\n-- Example queries for sqlc\r\nCREATE TABLE boxs (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  color colors\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: GetBoxes :many\r\nSELECT * FROM boxs\r\nWHERE \r\nCASE\r\n\tWHEN sqlc.narg('color') :: colors != null THEN\r\n\t\tcolor = sqlc.narg('color')\r\n\tELSE true\r\nEND;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n_No response_\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/b269211b4c484293e3e7f8b370d501075e0a355375be9abe1dfb344915601285\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/Emyrk","@type":"Person","name":"Emyrk"},"datePublished":"2022-06-16T00:40:50Z","url":"https://github.com/sqlc-dev/sqlc/issues/1683"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:815fb064-3b51-cb66-e10c-6c608a68ba25
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id9C72:E9D16:1956474:2011D3C:6B018056
html-safe-nonce799c27b7cbabf647570ce9dd272fe1e396ea584d7500fd8ea8f797f880443c8b
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QzcyOkU5RDE2OjE5NTY0NzQ6MjAxMUQzQzo2QjAxODA1NiIsInZpc2l0b3JfaWQiOiI0MDc5OTI0MjU5NTg0MDQ5MjM4IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmace352a73bb5f102c31b5ffd456c0bb69b80c58f6e246b39858a6f1e4601e932e5
hovercard-subject-tagissue:1272907087
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/1683/issue_layout
twitter:imagehttps://opengraph.githubassets.com/2bf0ef998ba535fedbfb002485692777c470040377f6f148c25c2c956a9c899f/sqlc-dev/sqlc/issues/1683
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/2bf0ef998ba535fedbfb002485692777c470040377f6f148c25c2c956a9c899f/sqlc-dev/sqlc/issues/1683
og:image:altVersion 1.14.0 What happened? sqlc.narg is a great addition. Unfortunately, it does not seem to work for enum types. I would really like to be able to use nullable enums, as empty strings are inval...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameEmyrk
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
go-importgithub.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git
octolytics-dimension-user_id136738596
octolytics-dimension-user_loginsqlc-dev
octolytics-dimension-repository_id193160679
octolytics-dimension-repository_nwosqlc-dev/sqlc
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id193160679
octolytics-dimension-repository_network_root_nwosqlc-dev/sqlc
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlc-dev/sqlc/issues/1683#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F1683
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F1683
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlc-dev%2Fsqlc
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1683
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1683
Reloadhttps://github.com/sqlc-dev/sqlc/issues/1683
sqlc-devhttps://github.com/sqlc-dev
sqlchttps://github.com/sqlc-dev/sqlc
Codehttps://github.com/sqlc-dev/sqlc
Issues600 (600)https://github.com/sqlc-dev/sqlc/issues
Pull requests132 (132)https://github.com/sqlc-dev/sqlc/pulls
Discussionshttps://github.com/sqlc-dev/sqlc/discussions
Actionshttps://github.com/sqlc-dev/sqlc/actions
Projectshttps://github.com/sqlc-dev/sqlc/projects
Security and qualityhttps://github.com/sqlc-dev/sqlc/security
Insightshttps://github.com/sqlc-dev/sqlc/insights
https://github.com/sqlc-dev/sqlc
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1683
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1683
sqlc.Narg does not work with enumshttps://github.com/sqlc-dev/sqlc/issues/1683#top
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
💻 linuxhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Acomputer%3A%20linux%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com/Emyrk
Emyrkhttps://github.com/Emyrk
on Jun 16, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issue-1272907087
https://play.sqlc.dev/p/b269211b4c484293e3e7f8b370d501075e0a355375be9abe1dfb344915601285https://play.sqlc.dev/p/b269211b4c484293e3e7f8b370d501075e0a355375be9abe1dfb344915601285
Emyrkhttps://github.com/Emyrk
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
on Jun 16, 2022https://github.com/sqlc-dev/sqlc/issues/1683#event-6817165920
https://github.com/eullerpereira94
eullerpereira94https://github.com/eullerpereira94
on Jun 24, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1165683544
https://github.com/Emyrk
Emyrkhttps://github.com/Emyrk
on Jun 24, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1165685652
https://github.com/eullerpereira94
eullerpereira94https://github.com/eullerpereira94
on Jun 24, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1165734707
https://github.com/eullerpereira94/sqlc_enum_testhttps://github.com/eullerpereira94/sqlc_enum_test
https://github.com/Emyrk
Emyrkhttps://github.com/Emyrk
on Jun 24, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1166113065
@eullerpereira94https://github.com/eullerpereira94
https://github.com/danielbprice
danielbpricehttps://github.com/danielbprice
on Jun 28, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1169279102
#1582https://github.com/sqlc-dev/sqlc/pull/1582
#1485https://github.com/sqlc-dev/sqlc/pull/1485
https://github.com/eullerpereira94
eullerpereira94https://github.com/eullerpereira94
on Jun 28, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1169337434
@danielbpricehttps://github.com/danielbprice
https://github.com/sbres
sbreshttps://github.com/sbres
on Jul 5, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1174860828
https://github.com/sbres
sbreshttps://github.com/sbres
on Jul 5, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1174899933
kyleconroyhttps://github.com/kyleconroy
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
💻 linuxhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Acomputer%3A%20linux%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
on Aug 20, 2022https://github.com/sqlc-dev/sqlc/issues/1683#event-7226905878
https://github.com/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Aug 29, 2022https://github.com/sqlc-dev/sqlc/issues/1683#issuecomment-1229694676
https://play.sqlc.dev/p/0ac3182108229aa90ff756658d45e2fc43c865517fa63f42c4339cb2b462a11ehttps://play.sqlc.dev/p/0ac3182108229aa90ff756658d45e2fc43c865517fa63f42c4339cb2b462a11e
kyleconroyhttps://github.com/kyleconroy
completedhttps://github.com/sqlc-dev/sqlc/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Aug 29, 2022https://github.com/sqlc-dev/sqlc/issues/1683#event-7274745003
kyleconroyhttps://github.com/kyleconroy
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
on Aug 29, 2022https://github.com/sqlc-dev/sqlc/issues/1683#event-7274745217
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/1683
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/1683
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
💻 linuxhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Acomputer%3A%20linux%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.