Problem with postgresql custom json datatype

[dspiteself]

Problem with postgresql custom json datatype

[bmizerany]

Will you please elaborate more on what you're trying to do, and with what code?

[dspiteself]

It seems all i have been doing is routine. Your driver has been
working like a charm. I will paste below the code that causes the
issue. My thought is that the issue could stem from data being a
custom type. it works fine if i remove data from the query and the
scan.

rows, err := db.Query("SELECT id, widget,(select coalesce(array_agg(subscription_id),'{}'::bigint[]) from rule_subscriptions where rule_id = rule_condition.id),'{}'::bigint[] ,data::text from rule_condition limit 1000") if err != nil { t.Error(err) } var id uint64 var rulearr string var subjectarr string var widget string var data string for rows.Next() { err := rows.Scan(&id, &widget, &rulearr, &subjectarr, &data) if err != nil { t.Error(err) } }

[bmizerany]

Can you give me a simple reproducible gist (gist.github.com) I can
clone? Or maybe add a test to conn_test.go in the repo? It's ok if it
fails; I just need it to build to better help you. You're example
below doesn't run through gofmt and is hard to get context.

On Mon, Apr 2, 2012 at 6:18 PM, dspiteself
[email protected]
wrote:

It seems all i have been doing is routine. Your driver has been
working like a charm. I will paste below the code that causes the
issue. My thought is that the issue could stem from data being a
custom type. it works fine if i remove data from the query and the
scan.

       rows, err := db.Query("SELECT id, widget,(select
coalesce(array_agg(subscription_id),'{}'::bigint[]) from
rule_subscriptions where rule_id = rule_condition.id),'{}'::bigint[]
,data::text from rule_condition limit 1000")
       if err != nil {
               t.Error(err)
       }
       var id uint64
       var rulearr string
       var subjectarr string
       var widget string
       var data string
       for rows.Next() {
               err := rows.Scan(&id, &widget, &rulearr, &subjectarr, &data)
               if err != nil {
                       t.Error(err)
}
}

On Mon, Apr 2, 2012 at 8:12 PM, Blake Mizerany
[email protected]
wrote:

Will you please elaborate more on what you're trying to do, and with what code?

---

Reply to this email directly or view it on GitHub:
bmizerany/pq#6 (comment)

Tyler Tallman
Project Manager
Breeze EMR
(m) [phone]

---

Reply to this email directly or view it on GitHub:
bmizerany/pq#6 (comment)

[dspiteself]

solved by bmizerany/pq@3cb21db