varchar function
jose' soares <sferac@bo.nettuno.it>
From: "jose' soares" <sferac@bo.nettuno.it>
To: pgsql-hackers@postgresql.org
Date: 1999-02-16T09:31:41Z
Lists: pgsql-hackers
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' -