varchar function

Started by jose' soaresalmost 27 years ago1 messages
#1jose' soares
sferac@bo.nettuno.it

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' -