Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index)

2019-02-04 Thread Ian Zimmerman
On 2019-02-04 05:34, Syed Jafri wrote: > |-|--|-|--| > | Receiver | Event | Date| > Location| > |-|--|-|--

Re: Syndicating PostgreSQL mailing list to Discourse

2018-05-25 Thread Ian Zimmerman
On 2018-05-25 14:03, Adrian Klaver wrote: > > If our mirror archive gets enough traction we'd like to make it > > possible to sign up to the forum and seamlessly interact with the > > mailing list, > > Well 'seamlessly works' would be the important part. In the past when > this was tried(can't re

Re: Query ID Values

2018-05-14 Thread Ian Zimmerman
On 2018-05-14 21:12, Adrian Klaver wrote: > Because you are doing fetchall(). That is going to fetch a list of row > tuples. Either iterate over that list or iterate over the cursor: > > for row in cur_p: > print(row) > > For more info see: > http://initd.org/psycopg/docs/cursor.html Whe