René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Min/Max on Datetimes result in interface{} as type","articleBody":"### Version\n\nOther\n\n### What happened?\n\nHint: I am using v1.13.0 (installed via brew) but that is not available in the form.\r\n\r\nI currently have a query that looks like this:\r\n```\r\nSELECT COUNT(*) as NumOfActivities,\r\n        MIN(event_time) as MinDate, \r\n        MAX(event_time) as MaxDate \r\nFROM activities \r\nWHERE account_id = $1\r\n```\r\nwhich creates a struct like this:\r\n```\r\ntype GetActivityMetaDataForAccountRow struct {\r\n\tNumofactivities int64\r\n\tMindate         interface{}\r\n\tMaxdate         interface{}\r\n}\r\n```\r\nbut I would expect\r\n```\r\ntype GetActivityMetaDataForAccountRow struct {\r\n\tNumofactivities int64\r\n\tMindate         time.Time\r\n\tMaxdate         time.Time\r\n}\r\n```\r\nso it looks like after putting a date through an aggregate-function sqlc can no longer determine its type? but it seems only to be the case for datetimes as far as I can see it.\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE activities (\r\n    account_id BIGINT NOT NULL,\r\n    event_time TIMESTAMP WITH TIME ZONE NOT NULL, \r\n);\n```\n\n\n### SQL queries\n\n```sql\nSELECT COUNT(*) as NumOfActivities,\r\n        MIN(event_time) as MinDate, \r\n        MAX(event_time) as MaxDate \r\nFROM activities \r\nWHERE account_id = $1\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\nmacOS\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/Neokil","@type":"Person","name":"Neokil"},"datePublished":"2022-04-27T14:52:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":14},"url":"https://github.com/1574/sqlc/issues/1574"}