Revision 13490
Added by Aaron Marcuse-Kubitza over 10 years ago
| util.sql | ||
|---|---|---|
| 1988 | 1988 |
CREATE FUNCTION in_reverse("array" anyarray) RETURNS SETOF anyelement
|
| 1989 | 1989 |
LANGUAGE sql IMMUTABLE |
| 1990 | 1990 |
AS $_$ |
| 1991 |
SELECT * FROM unnest($1) ORDER BY row_number() OVER () DESC
|
|
| 1991 |
SELECT elem FROM unnest($1) elem ORDER BY row_number() OVER () DESC
|
|
| 1992 | 1992 |
$_$; |
| 1993 | 1993 |
|
| 1994 | 1994 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: in_reverse(): can't use `SELECT *` for composite types because this expands them