Home > mailing lists

Get error when calling function that returns a table - Mailing list pgsql-sql

From	Russell Rose \| Passfield Data Systems
Subject	Get error when calling function that returns a table
Date	March 25 18:43:11
Msg-id	VI1P191MB0638AA48C8FA4AC3CC71B5B9F2362@VI1P191MB0638.EURP191.PROD.OUTLOOK.COM Whole thread Raw
Responses	Re: Get error when calling function that returns a table (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

I have got a procedure (test.sql) and this calls a function (test_rr.sql) which returns a table. I use the SQL:

Call test();

I get the error:

ERROR: invalid input syntax for type integer: "(14891,0,"VIMALBA ","P901 ",111.000000)"

CONTEXT: PL/pgSQL function test() line 13 at FETCH

SQL state: 22P02

Can anyone help please

Russell Rose

From: Tom Lane
Date: 25 March, 16:48:26
Subject: Re: decode/encode backslash to base64

From: Tom Lane
Date: 25 March, 19:26:43
Subject: Re: Get error when calling function that returns a table