prepared statement and inet type

[AlbertAguirre]

I prepared an insert statement into a postgres DB for a column that is an inet data type

I get the following error:
DBD:g::st execute failed: ERROR: invalid input syntax for type inet: "NULL"

Why?

I know I can insert a null into an inet type.

 

[travs69]

you can if you did not specify "not null" when creating the column in the table.

If not null was specified the data type is irrelevant.

 

[AlbertAguirre]

nulls are allowed in the table. When I do a manual insert statement by typing out the sql statement it works. But with a prepared statement in perl it does not.

Ideas?

 

[travs69]

Can you show us the statement you are trying to use?

 

[AlbertAguirre]

I think I figured it out.

I am using the ? placeholder in my prepare. The problem is that postgres requires a ' single quote in some columns and not in others.

With the ? placeholder perl places a ' single quote in all the values.

The solution was to prepare a statement WITHOUT the ? placeholder.

Any one disagree?

 

[travs69]

I have always just used a single quote for everything other than null's in postrgres