readthefuckingmanual.net

[SOLVED] ERROR: column foo is of type point but expression is of type record

Error added: 2006-11-29T11:22:42Z

2 people waiting for the answer...

1 answers found.

is the column of the type point or point[].

for some reason you cant create point but only point[] columns using pgadminIII.

for point the syntax is:

insert into test (point_column) values (\'(1,2)\')

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.

If you want to be notified via email when this is solved, enter your email address here: