I'm trying to test out the json type in PostgreSQL 9.3. I have a json column called data in a table …
sql json postgresql jsonb lateralMy use case is I am having one table in hive which has one column as INT and one as …
view hive sample query-by-example lateralI need to migrate SQL queries written for MS SQL Server 2005 to Postgres 9.1. What is the best way to substitute …
sql postgresql postgresql-9.1 cross-apply lateralRecently upgraded to using PostgreSQL 9.3.1 to leverage the JSONfunctionalities. In my table I have a json type column that has …
sql json postgresql postgresql-9.3 lateralI have the following data in a matches table: 5;{"Id":1,"Teams":[{"Name":"TeamA","Players":[{"Name":"AAA"},{"Name":"BBB"}]},{"Name":"TeamB","…
sql json postgresql greatest-n-per-group lateralGiven a table defined as such: CREATE TABLE test_values(name TEXT, values INTEGER[]); ...and the following values: | name | values | +…
sql arrays postgresql set-returning-functions lateralI am trying to join table and function which returns rows: SELECT p.id, p.name, f.action, f.amount …
sql postgresql join set-returning-functions lateralI have the following query: query = "SELECT data #>> '{id}' AS id, data #>> '{name}…
sql postgresql correlated-subquery jsonb lateral