| From: | Russell Rose | Passfield Data Systems <russellrose(at)passfield(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Get error when calling function that returns a table |
| Date: | 2024-03-25 15:43:11 |
| Message-ID: | VI1P191MB0638AA48C8FA4AC3CC71B5B9F2362@VI1P191MB0638.EURP191.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| test_rr.sql | application/octet-stream | 517 bytes |
| test.sql | application/octet-stream | 509 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2024-03-25 16:26:43 | Re: Get error when calling function that returns a table |
| Previous Message | Tom Lane | 2024-03-25 13:48:26 | Re: decode/encode backslash to base64 |