#create table t (v varchar);
#insert into t values ('0123456789a0123456789b0123456789c0123456789d');
#select v from t;
v
----------------------------------------------
0123456789a0123456789b0123456789c0123456789d
(1 row)
So far, so good.
#select text(v) from t;
text
---------------------------------
0123456789a0123456789b012345678
(1 row)
Truncation occurs.
Work around:
# select v::text from t;
?column?
----------------------------------------------
0123456789a0123456789b0123456789c0123456789d
(1 row)
I couldnt figure out what happens during a text(varchar) call. I looked
around in pg_proc, but couldnt find the function. There's probably an
automagic type conversion going on or something.
Could someone explain what all the internal varchar-like types are (ie.
varchar,varchar(n),text,char,_char,bpchar) and when they're used? I
find it all really confusing - I'm sure others do too.
Is there anyway to determine what postgresql is doing in its automagic
function calls? I guess I'm asking for an EXPLAIN that describes
function calls. For example,
EXPLAIN select text(v) from t;
--> {Description of conversion from varchar to whatever the text()
function actually works on}
Thanks,
dave
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
