varchar function

From: "jose' soares" <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: varchar function
Date: 1999-02-16 09:31:41
Message-ID: 36C93AFD.5B9FA962@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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' -

Browse pgsql-hackers by date

  From Date Subject
Next Message Randy Singh 1999-02-16 11:06:19 Help for running initdb
Previous Message The Hermit Hacker 1999-02-16 06:14:30 Might already be fixed...?