From: | mohanpatil048(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | mohanpatil048(at)gmail(dot)com |
Subject: | BUG #14969: Delta in 9.6 and 10 |
Date: | 2017-12-12 16:09:21 |
Message-ID: | 20171212160921.20160.94349@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14969
Logged by: Mohan Patil
Email address: mohanpatil048(at)gmail(dot)com
PostgreSQL version: 10.1
Operating system: ubuntu 14.04
Description:
When I execute the below query in 9.6 version,I get the result.
But when I execute it on 10.1, it is giving the error,
********** Error **********
ERROR: set-returning functions are not allowed in CASE
SQL state: 0A000
Hint: You might be able to move the set-returning function into a LATERAL
FROM item.
QUERY::
SELECT t.id, t.name
FROM (SELECT ( CASE
WHEN CARDINALITY(tier_ids) > 1 THEN UNNEST(tier_ids)
ELSE NULL
END ) AS tier_id
FROM relation
WHERE id = 1001) AS d
INNER JOIN tier t ON t.id = d.tier_id ;
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim Gündüz | 2017-12-12 16:33:40 | Re: BUG #14968: package postgresql93-server-9.3.20-3PGDG.rhel7.x86_64 fails to start |
Previous Message | Jan Schulz | 2017-12-12 13:54:58 | Re: BUG #14948: cost overflow |