varchar function
Hi,
There are some VARCHAR built-in functions, but I can't use them...
hygea=> \df varchar
result |function |arguments |description
-------+---------------+--------------+---------------------
bool |varchareq |varchar varcha|equal
bool |varcharge |varchar varcha|greater-than-or-equal
bool |varchargt |varchar varcha|greater-than
bool |varcharle |varchar varcha|less-than-or-equal
bool |varcharlt |varchar varcha|less-than
bool |varcharne |varchar varcha|not equal
int4 |varcharcmp |varchar varcha|less-equal-greater
int4 |varcharlen |varchar |character length
int4 |varcharoctetlen|varchar |octet length
varchar|varchar |name |convert
varchar|varchar |varchar int4 |
(11 rows)
hygea=> select varchar('boo'::varchar,12);
ERROR: parser: parse error at or near "'"
hygea=> select varchar('boo'::name);
ERROR: parser: parse error at or near "'"
- Jose' -