René's URL Explorer Experiment

Title: Insert statement should support WITH clause · Issue #2350 · sqlc-dev/sqlc · GitHub

Open Graph Title: Insert statement should support WITH clause · Issue #2350 · sqlc-dev/sqlc

X Title: Insert statement should support WITH clause · Issue #2350 · sqlc-dev/sqlc

Description: What do you want to change? The query: INSERT INTO some_table WITH foo AS ( ... ) SELECT ... FROM another_table JOIN foo ON ... WHERE ... The error: relation "foo" does not exist What database engines need to be changed? PostgreSQL What ...

Open Graph Description: What do you want to change? The query: INSERT INTO some_table WITH foo AS ( ... ) SELECT ... FROM another_table JOIN foo ON ... WHERE ... The error: relation "foo" does not exist What database engi...

X Description: What do you want to change? The query: INSERT INTO some_table WITH foo AS ( ... ) SELECT ... FROM another_table JOIN foo ON ... WHERE ... The error: relation "foo" does not exist What dat...

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

X: @github

direct link

Domain: github.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Insert statement should support WITH clause","articleBody":"### What do you want to change?\n\nThe query:\r\n\r\n```sql\r\nINSERT INTO some_table\r\nWITH foo AS (\r\n...\r\n)\r\nSELECT ...\r\nFROM another_table\r\nJOIN foo ON ...\r\nWHERE ...\r\n```\r\n\r\nThe error:\r\n```\r\nrelation \"foo\" does not exist\r\n```\n\n### What database engines need to be changed?\n\nPostgreSQL\n\n### What programming language backends need to be changed?\n\nGo","author":{"url":"https://github.com/odannyc","@type":"Person","name":"odannyc"},"datePublished":"2023-06-21T15:41:59.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2350/sqlc/issues/2350"}

Links:

Viewport: width=device-width