René's URL Explorer Experiment


Title: PostgreSQL arrays can have NULL items · Issue #185 · sqlc-dev/sqlc · GitHub

Open Graph Title: PostgreSQL arrays can have NULL items · Issue #185 · sqlc-dev/sqlc

X Title: PostgreSQL arrays can have NULL items · Issue #185 · sqlc-dev/sqlc

Description: Given the following schema and query: CREATE TABLE foo ( id text NOT NULL, tags text[] ); -- name: ListFoo :many SELECT * FROM foo; sqlc will generate the following code: // Code generated by sqlc. DO NOT EDIT. package main import ( "con...

Open Graph Description: Given the following schema and query: CREATE TABLE foo ( id text NOT NULL, tags text[] ); -- name: ListFoo :many SELECT * FROM foo; sqlc will generate the following code: // Code generated by sqlc....

X Description: Given the following schema and query: CREATE TABLE foo ( id text NOT NULL, tags text[] ); -- name: ListFoo :many SELECT * FROM foo; sqlc will generate the following code: // Code generated by sqlc....

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"PostgreSQL arrays can have NULL items","articleBody":"Given the following schema and query: \r\n\r\n```sql\r\nCREATE TABLE foo (\r\n        id text NOT NULL,\r\n        tags text[]\r\n);\r\n\r\n-- name: ListFoo :many\r\nSELECT * FROM foo;\r\n```\r\n\r\nsqlc will generate the following code:\r\n\r\n```go\r\n// Code generated by sqlc. DO NOT EDIT.\r\n\r\npackage main\r\n\r\nimport (\r\n\t\"context\"\r\n\t\"database/sql\"\r\n\r\n\t\"github.com/lib/pq\"\r\n)\r\n\r\ntype Foo struct {\r\n\tID   sql.NullString\r\n\tTags []string\r\n}\r\n\r\nconst listFoo = `-- name: ListFoo :many\r\nSELECT id, tags FROM foo\r\n`\r\n\r\nfunc (q *Queries) ListFoo(ctx context.Context) ([]Foo, error) {\r\n\trows, err := q.db.QueryContext(ctx, listFoo)\r\n\tif err != nil {\r\n\t\treturn nil, err\r\n\t}\r\n\tdefer rows.Close()\r\n\tvar items []Foo\r\n\tfor rows.Next() {\r\n\t\tvar i Foo\r\n\t\tif err := rows.Scan(&i.ID, pq.Array(&i.Tags)); err != nil {\r\n\t\t\treturn nil, err\r\n\t\t}\r\n\t\titems = append(items, i)\r\n\t}\r\n\tif err := rows.Close(); err != nil {\r\n\t\treturn nil, err\r\n\t}\r\n\tif err := rows.Err(); err != nil {\r\n\t\treturn nil, err\r\n\t}\r\n\treturn items, nil\r\n}\r\n\r\ntype DBTX interface {\r\n\tExecContext(context.Context, string, ...interface{}) (sql.Result, error)\r\n\tPrepareContext(context.Context, string) (*sql.Stmt, error)\r\n\tQueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)\r\n\tQueryRowContext(context.Context, string, ...interface{}) *sql.Row\r\n}\r\n\r\nfunc New(db DBTX) *Queries {\r\n\treturn &Queries{db: db}\r\n}\r\n\r\ntype Queries struct {\r\n\tdb DBTX\r\n}\r\n\r\nfunc (q *Queries) WithTx(tx *sql.Tx) *Queries {\r\n\treturn &Queries{\r\n\t\tdb: tx,\r\n\t}\r\n}\r\n```\r\n\r\nWith the following two records inserted into the `foo` table, a call `ListFoos` succeeds.\r\n\r\n```sql\r\nINSERT INTO foo (id, tags) VALUES ('one', NULL);\r\nINSERT INTO foo (id, tags) VALUES ('two', array['tag']);\r\n```\r\n\r\nHowever, if a NULL item exists in the `tags` array, an error will be returned.\r\n\r\n```sql\r\nINSERT INTO foo (id, tags) VALUES ('one', array[NULL]);\r\n```\r\n\r\n```\r\nsql: Scan error on column index 1, name \"tags\": pq: parsing array element index 0: cannot convert nil to string\r\n```\r\n\r\nThat's not a problem, right? We'll just mark the `tags` column as not null. Sadly, that just means that the column must contain an array value. The array itself can still contain NULL values. It does not appear to be easy to prevent NULL values in arrays. This was the [only solution](Declare a column of type 'not-null-string' array in postgresql - Stack Overflow) I could find, and it's pretty gross. \r\n\r\nNote that `pq.StringArray` also does not support NULL array values.","author":{"url":"https://github.com/kyleconroy","@type":"Person","name":"kyleconroy"},"datePublished":"2019-12-16T22:05:05Z","url":"https://github.com/sqlc-dev/sqlc/issues/185"}

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:eb0a9ae9-5c62-b56e-2a96-77cfb22b5b8e
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id93EA:6365:1F2A257:29915C9:6B017A6A
html-safe-nonce1c3641cf2c730c07e8971531dd8c665a95a16075addc7c6763bda2a6f552a0e4
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5M0VBOjYzNjU6MUYyQTI1NzoyOTkxNUM5OjZCMDE3QTZBIiwidmlzaXRvcl9pZCI6IjU4OTkxMjIzNTcxOTIxOTQ2NjYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacc183e285f6331f96bda27c9045a9c3c4610c05a29462436a0f13acd94e35a3c6
hovercard-subject-tagissue:538693220
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/185/issue_layout
twitter:imagehttps://opengraph.githubassets.com/5ba2264b245ec08c78c3faee28cadc9f307c433e8533a0bd16bfcf1911caa451/sqlc-dev/sqlc/issues/185
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/5ba2264b245ec08c78c3faee28cadc9f307c433e8533a0bd16bfcf1911caa451/sqlc-dev/sqlc/issues/185
og:image:altGiven the following schema and query: CREATE TABLE foo ( id text NOT NULL, tags text[] ); -- name: ListFoo :many SELECT * FROM foo; sqlc will generate the following code: // Code generated by sqlc....
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamekyleconroy
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/185#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F185
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%2F185
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/185
Reloadhttps://github.com/sqlc-dev/sqlc/issues/185
Reloadhttps://github.com/sqlc-dev/sqlc/issues/185
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/185
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/185
PostgreSQL arrays can have NULL itemshttps://github.com/sqlc-dev/sqlc/issues/185#top
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%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/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Dec 16, 2019https://github.com/sqlc-dev/sqlc/issues/185#issue-538693220
kyleconroyhttps://github.com/kyleconroy
bugSomething isn't workinghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22bug%22
on Dec 16, 2019https://github.com/sqlc-dev/sqlc/issues/185#event-2887663105
https://github.com/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Dec 16, 2019https://github.com/sqlc-dev/sqlc/issues/185#issuecomment-566266412
kyleconroyhttps://github.com/kyleconroy
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
on Aug 28, 2021https://github.com/sqlc-dev/sqlc/issues/185#event-5222007283
https://github.com/dimmerz92
dimmerz92https://github.com/dimmerz92
on Apr 26, 2024https://github.com/sqlc-dev/sqlc/issues/185#issuecomment-2079688211
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/185
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/185
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%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.