PostgreSQL - can't save items - "type integer but expression is of type character"

Posted by user984621 on Stack Overflow See other posts from Stack Overflow or by user984621
Published on 2012-03-29T23:25:44Z Indexed on 2012/03/29 23:29 UTC
Read the original article Hit count: 415

Filed under:

types

|

integer

|

expression

|

varchar

I am getting still over and over again this error, the column age has the type integer, I am saving into this column integer-value, I also tried to don't save nothing into this column, but still getting this error...

Could anyone help me, how to fix that?

PG::Error: ERROR:  column "age" is of type integer but expression is of type character varying at character 102
HINT:  You will need to rewrite or cast the expression.
: INSERT INTO "user_details" ("created_at", "age", "updated_at", "user_id") VALUES ($1, $2, $3, $4) RETURNING "id"

© Stack Overflow or respective owner

Related posts about types

value types in the vm

as seen on Oracle Blogs - Search for 'Oracle Blogs'
value types in the vm p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px Times} p.p2 {margin: 0.0px 0.0px 14.0px 0.0px; font: 14.0px Times} p.p3 {margin: 0.0px 0.0px 12.0px 0.0px; font: 14.0px Times} p.p4 {margin: 0.0px 0.0px 15.0px 0.0px; font: 14.0px Times} … >>> More
How can I get PowerShell Added-Types to use Added Types

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on a PoSh project that generates CSharp code, and then Add-Types it into memory. The new types use existing types in an on disk DLL, which is loaded via Add-Type. All is well and good untill I actualy try to invoke methods on the new types. Here's an example of what I'm doing: $PWD… >>> More
NDepend query methods/types in framework assembly being used by other assemblies/types

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to determine which types or methods in a base framework assembly are being used by other assemblies in the application system. I cannot seem to find a straight-cut query to do that. What i have to do is first determine which assemblies are directly using the framework assembly, then manually… >>> More
Concrete Types or Interfaces for return types?

as seen on Stack Overflow - Search for 'Stack Overflow'
Today I came to a fundamental paradox of the object programming style, concrete types or interfaces. Whats the better election for a method's return type: a concrete type or an interface? In most cases, I tend to use concrete types as the return type for methods. because I believe that an concrete… >>> More
Using Scala structural types with abstract types

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to define a structural type defining anything that has an "add" method (for instance, a java collection or a java map). Using this, I want to define a few higher order functions that operate on a certain collection object GenericTypes { type GenericCollection[T] = { def add(value: T):… >>> More

Related posts about integer

Finding out why Dell Controler is Degraded

as seen on Server Fault - Search for 'Server Fault'
I installed open manage on a couple of my PE 2950s for snmp monitoring of the RAID. All the checks seem to come back okay except for controllerState: [root@aMachine ~]# snmpwalk -v 2c -c bestNotToPostPasswords myMachine -m +StorageManagement-MIB controllerstate StorageManagement-MIB::controllerState… >>> More
Bit reversal of an integer, ignoring integer size and endianness

as seen on Stack Overflow - Search for 'Stack Overflow'
Given an integer typedef: typedef unsigned int TYPE; or typedef unsigned long TYPE; I have the following code to reverse the bits of an integer: TYPE max_bit= (TYPE)-1; void reverse_int_setup() { TYPE bits= (TYPE)max_bit; while (bits <<= 1) max_bit= bits; } TYPE reverse_int(TYPE… >>> More
What is a Delphi version of the C++ header for the DVP7010B video card DLL?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need help with converting c++ header file to delphi. I spent several days on this problem without success. Below is the original header file and my Delphi translation. C++ header #if _MSC_VER > 1000 #pragma once #endif // _MSC_VER > 1000 #ifdef DVP7010BDLL_EXPORTS #define DVP7010BDLL_API… >>> More
Need help converting a C++ header file to delphi

as seen on Stack Overflow - Search for 'Stack Overflow'
I need help with converting c++ header file to delphi. I spent several days on this problem without success. Below is the original header file and my Delphi translation. ///////////////////////// C++ header file //////////////////////////////////// if _MSC_VER 1000 pragma once endif // _MSC_VER… >>> More
SQLiteOpenHelper.getWriteableDatabase() null pointer exception on Android

as seen on Stack Overflow - Search for 'Stack Overflow'
I've had fine luck using SQLite with straight, direct SQL in Android, but this is the first time I'm wrapping a DB in a ContentProvider. I keep getting a null pointer exception when calling getWritableDatabase() or getReadableDatabase(). Is this just a stupid mistake I've made with initializations… >>> More