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: | Whole Thread | Raw Message | 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' -
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...? |