Top "Set-returning-functions" questions

PostgreSQL error: set-returning functions are not allowed in CASE

I tried to run this query in PostgreSQL 10: select e.errordescription, CASE WHEN e.reworkempid is not null THEN get_…

sql postgresql set-returning-functions postgresql-10

What's the proper index for querying structures in arrays in Postgres jsonb?

I'm experimenting with keeping values like the following in a Postgres jsonb field in Postgres 9.4: [{"event_slug":"test_1","start_time":"2014…

sql postgresql indexing set-returning-functions jsonb

How to select multiple rows filled with constants in Amazon Redshift?

I have already tried the common PostgreSQL answer, but seems like it doesn't work with Redshift: SELECT * FROM VALUES (1) AS …

sql postgresql amazon-redshift set-returning-functions