#1 2023-07-04 10:41:22

felipe
Member
Registered: 2023-05-11

Error when trying to preview dynamic list

how to select these field that has this double quote

PSQLException: ERROR: trailing junk after numeric literal at or near "001_"

Offline

#2 2023-07-04 14:58:04

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Error when trying to preview dynamic list

Hi felipe,

this is a postgres error.
If you google for this error you should find tons of information, e.g. https://stackoverflow.com/questions/745 … postgresql

Specifically, it is warning about unexpected characters after numeric literals. In the text that is printed we can see five digits (63711) followed by the character a. It seems that the code is attempting to parse this set of characters as a number and failing to do so once it finds the first alpha character.

Regards,
Eduardo

Offline

#3 2023-07-04 15:18:19

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Error when trying to preview dynamic list

Hi felipe,

this works in my case:
select '001_x' as x, * from RS_USER

if you have any different query pls try a simple one containing only your field and check if it works.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB