varchar function - Mailing list pgsql-hackers

From jose' soares
Subject varchar function
Date
Msg-id 36C93AFD.5B9FA962@bo.nettuno.it
Whole thread Raw
List pgsql-hackers
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 />  

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Might already be fixed...?
Next
From: Thomas Reinke
Date:
Subject: [Fwd: [HACKERS] JDBC lo crashes etc (fwd)]