TechQA.

Question

JSONB: more than one row returned by a subquery used as an expression

score 5339 · Answer 1 · 2015-06-16T02:10:27.907000

0

Answer

5339

Views

JSONB: more than one row returned by a subquery used as an expression

5.3k views Asked by AudioBubble At 16 June 2015 at 02:10

score 2815 · Answer 2 · 2015-06-25T08:29:42.810000

How to insert the output of set-returning function into a table

2.8k views Asked by Raghu At 25 June 2015 at 08:29

score 1911 · Answer 3 · 2014-11-21T17:21:05.400000

Generic set returning function

1.9k views Asked by Saurabh At 21 November 2014 at 17:21

score 7714 · Answer 4 · 2014-11-26T11:54:05.167000

Split string with two delimiters and convert type

7.7k views Asked by sataide At 26 November 2014 at 11:54

score 11488 · Answer 5 · 2013-08-23T14:12:43.540000

Returning result set from Postgres functions

11.4k views Asked by nick_v1 At 23 August 2013 at 14:12

score 1093 · Answer 6 · 2014-12-03T09:33:14.833000

Non-scalar correlated subqueries in select?

1k views Asked by foobar0100 At 03 December 2014 at 09:33

score 226 · Answer 7 · 2014-12-08T08:14:37.303000

Use cases for lateral that do not involve a set returning function

226 views Asked by ajw0100 At 08 December 2014 at 08:14

score 3227 · Answer 8 · 2014-12-16T22:37:39.323000

Combined SELECT from unnested composite type array and regular column

3.2k views Asked by dupes At 16 December 2014 at 22:37

score 121 · Answer 9 · 2023-10-25T02:59:16.760000

Scope and functionality of table functions

121 views Asked by okzoomer At 25 October 2023 at 02:59

score 3869 · Answer 10 · 2012-05-15T02:17:32.280000

Remove braces from regular expression result

3.8k views Asked by Dave Jarvis At 15 May 2012 at 02:17

score 675 · Answer 11 · 2022-04-18T02:38:50.793000

PostgreSQL function returns one column instead of 4 columns

675 views Asked by Debra Ray At 18 April 2022 at 02:38

score 975 · Answer 12 · 2021-05-06T12:29:42.360000

Create function that returns table doesn't work syntax error? SQL

975 views Asked by AxelF At 06 May 2021 at 12:29

score 107996 · Answer 13 · 2013-08-06T15:55:01.290000

PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement

107.9k views Asked by Getz At 06 August 2013 at 15:55

score 1413 · Answer 14 · 2021-05-31T08:59:17.240000

PostgreSQL jsonb_path_query removes result instead of returning null value

1.4k views Asked by Isaac N At 31 May 2021 at 08:59

score 103 · Answer 15 · 2016-02-14T05:10:57.193000

How can I retrieve the set returned from a STR into a model via ecto?

103 views Asked by Daniel Marín At 14 February 2016 at 05:10

score 95 · Answer 16 · 2023-01-18T09:13:52.027000

Split multi-bracket data (JSON arrays) into rows preserving associations

95 views Asked by sahil At 18 January 2023 at 09:13

score 391 · Answer 17 · 2020-07-21T06:26:20.660000

Function that takes id and returns the table - how to call it for multiple ids?

391 views Asked by jakes At 21 July 2020 at 06:26

score 9951 · Answer 18 · 2014-05-23T13:48:29.247000

Parallel unnest() and sort order in PostgreSQL

9.9k views Asked by Jerome WAGNER At 23 May 2014 at 13:48

score 3077 · Answer 19 · 2014-05-27T11:50:15.827000

Postgres function returning one record while I have many records?

3k views Asked by user3664724 At 27 May 2014 at 11:50

score 1272 · Answer 20 · 2014-05-26T23:28:34.600000

Multiply elements in an array according to their position

1.2k views Asked by Nick At 26 May 2014 at 23:28

TechQA.

List Question

JSONB: more than one row returned by a subquery used as an expression

How to insert the output of set-returning function into a table

Generic set returning function

Split string with two delimiters and convert type

Returning result set from Postgres functions

Non-scalar correlated subqueries in select?

Use cases for lateral that do not involve a set returning function

Combined SELECT from unnested composite type array and regular column

Scope and functionality of table functions

Remove braces from regular expression result

PostgreSQL function returns one column instead of 4 columns

Create function that returns table doesn't work syntax error? SQL

PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement

PostgreSQL jsonb_path_query removes result instead of returning null value

How can I retrieve the set returned from a STR into a model via ecto?

Split multi-bracket data (JSON arrays) into rows preserving associations

Function that takes id and returns the table - how to call it for multiple ids?

Parallel unnest() and sort order in PostgreSQL

Postgres function returning one record while I have many records?

Multiply elements in an array according to their position

Popular Questions

Popular Tags

Trending Questions