2009/4/1 Alvaro Herrera <[email protected]>: > Pavel Stehule escribió: >> Hello >> >> I am sending samples of transformation hook modules. One module is >> JSON support:. >> >> From these modules only JSON support has general usage - so only JSON >> should be integrated to core. > > I'm only seeing trivial examples below, where you form the JSON objects > by plastering literals together. Does this work on a scenario where the > values come from a table?
what do you thing? My implementation works similar like SQL/XML functions - so of course, you can read data from tables. But actually, these functions are not 100% optimised. > > The question is not at all theoretical -- right now our > archives.postgresql.org site uses a JSON file that's just a dump of a > table in a database. This file contains a list of lists, and a number > of properties for each (name, group it belongs to, description). > Obviously each one needs its label too. nested JSON structures are possible. Pavel Stehule > > Right now we generate this with a JSON Perl module. > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
