CODEWITHSUNDEEP
postgresqlplpgsql
Oto Shavadze
Oto Shavadze

Reputation: 42773

Add element to empty array

In plpgSql, I need to add number to empty numeric array, this empty numeric array is variable.

What I do is this: 

DECLARE
    new_arr INTEGER[];
BEGIN
    SELECT array_append(new_arr, 4) INTO new_arr;

This works, but I am not sure, may be exists better way for this?

Upvotes: 5

Views: 9791

Answers (1)

Pavel Stehule
Pavel Stehule

Reputation: 45835

You can do it, but this style is little bit obscure

use a assign statement, but you don't need a forget a correct initialization. In your example a new_arr doesn't hold a empty array. It holds a NULL. Do:

DECLARE new_arr int[] DEFAULT '{}';
BEGIN
  new_arr := new_arr || 4;
  -- or
  new_arr := array_append(new_arr, 4);

  -- both are equal

SELECT INTO should be used if you do query to some relation.

Upvotes: 18

Related Questions