Postgres Pro
Downloads
Home   >   mailing lists

Re: plphyton function - return each list value as a row ? - Mailing list pgsql-sql

From David G. Johnston
Subject Re: plphyton function - return each list value as a row ?
Date
Msg-id CAKFQuwbWaLSuWrCEjYSkBMU8NqtGc82yN3BSEFx===rD7ONDbA@mail.gmail.com
Whole thread Raw
In response to plphyton function - return each list value as a row ?  ("karsten" <karsten@terragis.net>)
List pgsql-sql
Tree view
On Saturday, July 25, 2020, karsten <karsten@terragis.net> wrote:
Hi All,

I am trying to create my first plphyton function ( retrieving earthquake
data from an API) .
Overall I was able to get one single row to be returned, but am struggling
how to return the entire list I have as multiple rows - see below. Currently
I get the following error when running the GetEartquakeAll function:

select GetEartquakeAll('2020-01-01' ,'2020-03-01', -120, 40,200, 1.7)
gives me
ERROR: length of returned sequence did not match number of columns in row

How can I 'simply' return each list value as a row ?
Thanks
Karsten Vennemann

CREATE OR REPLACE FUNCTION GetEartquakeAll(start date ,stop date, lon float,
lat float,radius int, minmagnitude float) RETURNS equake_values AS $$

The choice of mailing list for this is unusual as this seems to have nothing to do with general SQL.

Anyway, you may find the following documentation section useful.


David J.

pgsql-sql by date:

Previous
From: "karsten"
Date:
Subject: plphyton function - return each list value as a row ?
Next
From: Mike Martin
Date:
Subject: UNNEST and multidimensional arrays