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



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' -
Tue, 16 Feb 1999 10:31:41 +0100
"jose' soares" <sferac@bo.nettuno.it>
varchar function