[HACKERS] [PATCH] Implement json_array_elements_text

2014-01-20 Thread Laurence Rowe
Following the discussion on pgsql-general, I thought I'd have a go implementing json_array_elements_text following the same pattern as json_each_text. The function makes it possible to join elements of a json array onto a table, for example: CREATE TABLE object (name TEXT PRIMARY KEY, properties

Re: [HACKERS] [PATCH] Implement json_array_elements_text

2014-01-20 Thread Laurence Rowe
On 20 January 2014 18:58, Laurence Rowe l...@lrowe.co.uk wrote: Following the discussion on pgsql-general, I thought I'd have a go implementing json_array_elements_text following the same pattern as json_each_text. This updated patch makes the return type of ``json_array_elements_text`` text

Re: [HACKERS] new json funcs

2014-01-24 Thread Laurence Rowe
For consistency with the existing json functions (json_each, json_each_text, etc.) it might be better to add separate json_to_record_text and json_to_recordset_text functions in place of the nested_as_text parameter to json_to_record and json_to_recordset. On 24 January 2014 10:26, Andrew

Re: [HACKERS] jsonb format is pessimal for toast compression

2014-08-26 Thread Laurence Rowe
On 26 August 2014 11:34, Josh Berkus j...@agliodbs.com wrote: On 08/26/2014 07:51 AM, Tom Lane wrote: My feeling about it at this point is that the apparent speed gain from using offsets is illusory: in practically all real-world cases where there are enough keys or array elements for it

Re: [HACKERS] A mechanism securing web applications in DBMS

2014-09-04 Thread Laurence Rowe
2.1 The authentication problem We address the authentication problem by requiring developers to define an authentication function in the DBMS. This function is invoked whenever an application-level user logs in. An authentication function contains the authentication logic in the