# ERROR: Invalid input syntax for type numeric "" inserting into PostgreSQL

**URL:** <https://clarionhub.com/t/error-invalid-input-syntax-for-type-numeric-inserting-into-postgresql/5590>\
**Category:** uncategorized\
**Created:** [November 3, 2022, 11:20am UTC](https://clarionhub.com/t/error-invalid-input-syntax-for-type-numeric-inserting-into-postgresql/5590 "2022-11-03T11:20:51Z")\
**Posts on this page:** 2\
**Page:** 2

<div class="post-metadata">

**Author:** ![ademirpiva](https://clarionhub.com/user_avatar/clarionhub.com/ademirpiva/32/5557_2.png) [@ademirpiva](https://clarionhub.com/u/ademirpiva)\
**Post date:** [November 8, 2022, 5:38pm UTC](https://clarionhub.com/t/error-invalid-input-syntax-for-type-numeric-inserting-into-postgresql/5590/22 "2022-11-08T17:38:01Z")

</div>

> [@ThalesSilveirs](#):
>
> using PostgreSQL on Clarion today?

Yes, I’m using PostgreSQL with Clarion.  
I can help.

---

<div class="post-metadata">

**Author:** ![ThalesSilveirs](https://clarionhub.com/user_avatar/clarionhub.com/thalessilveirs/32/3642_2.png) [@ThalesSilveirs](https://clarionhub.com/u/ThalesSilveirs)\
**Post date:** [November 14, 2022, 1:25pm UTC](https://clarionhub.com/t/error-invalid-input-syntax-for-type-numeric-inserting-into-postgresql/5590/23 "2022-11-14T13:25:30Z")

</div>

SOLUTION: In my Dictionary, it was converted from C5 to C9, and in this conversion, it had a VERSION field in the table options, so it gave the error, now even creating, it creates.

 ![image](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/8/83beb789668b2d70bbf592e84a276c2c5876ffa5.png)

[Previous page](https://clarionhub.com/t/error-invalid-input-syntax-for-type-numeric-inserting-into-postgresql/5590.md?page=1)