Обсуждение: varchar function

Поиск
Список
Период
Сортировка

varchar function

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