You are not logged in.
how to select these field that has this double quote
PSQLException: ERROR: trailing junk after numeric literal at or near "001_"
Offline
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
Online
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
Online