Postgres Pro
Downloads
Home   >   mailing lists

Re: Invalid syntax for integer - Mailing list pgsql-novice

From David Jarvis
Subject Re: Invalid syntax for integer
Date
Msg-id AANLkTikqQRx94ydGVqqIQjDXfaS-W9On5eA5HUpTe_IH@mail.gmail.com
Whole thread Raw
In response to Re: Invalid syntax for integer  (David Jarvis <thangalin@gmail.com>)
List pgsql-novice
Tree view
Hi,

The work-around is as follows:

    IF array_length( v_id, 1 ) = 1 THEN
      SELECT array_append( v_id, NULL ) INTO v_id;
    END IF;

    result := climate.plr_stations( v_id, v_latitude, v_longitude, latitude, longitude );

This now works when v_id contains a single element.

Dave

pgsql-novice by date:

Previous
From: David Jarvis
Date:
Subject: Re: Invalid syntax for integer
Next
From: "Lennart Ripke"
Date:
Subject: How to use search_path in CASE