public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Vladimir Ryabtsev <[email protected]>
Cc: [email protected]
Subject: Re: Array of tuples as a parameter, with type casts
Date: Wed, 4 Dec 2019 10:44:47 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMqTPqk_d9kcuVrEwnu7dY5XKSh7BQQwvUBpKNciTTrhcxnORw@mail.gmail.com>
References: <CAMqTPqntVMh1sk6V2GbwqX8ti7RtN2wQLVS-tYfVuVh8qWc4Tw@mail.gmail.com>
<[email protected]>
<CAMqTPqk_d9kcuVrEwnu7dY5XKSh7BQQwvUBpKNciTTrhcxnORw@mail.gmail.com>
On 12/3/19 4:00 PM, Vladimir Ryabtsev wrote:
> It does not change much, the error message just says it now expects
> 'character varying'.
> Anyway bigint problem is the next in the line.
Yeah it is related to this:
https://www.postgresql.org/docs/11/functions-array.html
unnest(anyarray) setof anyelement
Dealing with anyelement can be tricky.
I tried out an alternate solution:
json_query = "select * from json_to_recordset(%s) as t(a timestamp, b
varchar, c bigint)"
cur.execute(json_query,[Json([{'a': datetime.now().isoformat(), 'b':
'abc', 'c': 100},{'a': datetime.now().isoformat(), 'b': 'xyz', 'c': 200}])])
Which results in:
test_(postgres)# select * from json_to_recordset(E'[{"a":
"2019-12-04T10:40:22.823910", "b": "abc", "c": 100}, {"a":
"2019-12-04T10:40:22.823918", "b": "xyz", "c": 200}]') as t(a timestamp,
b varchar, c bigint)
;
a | b | c
----------------------------+-----+-----
2019-12-04 10:40:22.82391 | abc | 100
2019-12-04 10:40:22.823918 | xyz | 200
(2 rows)
>
> --
> Regards,
> Vladimir
--
Adrian Klaver
[email protected]
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Array of tuples as a parameter, with type casts
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox