Newbie question about datatype conversion
От | Andrew Douglas |
---|---|
Тема | Newbie question about datatype conversion |
Дата | |
Msg-id | 199903291315.IAA25920@websmtp1.bellsouth.bigfoot.com обсуждение исходный текст |
Список | pgsql-sql |
I can't seem to figure out how to convert a varchar to a text or a text to char or anything. I've tried doing exactly asthe good documentation says but this is the kind of response I get. foo=> select orgname from organization; orgname ---------------------- Douglas Ventures BobMart (2 rows) foo=> \d organization; <---SNIP---> | orgname | varchar() not null | 25 | <---SNIP---> foo=> select text(orgname) from organization; ERROR: function text(varchar) does not exist foo=> select orgname::text from organization; ERROR: function text(varchar) does not exist foo=> select char(orgname) from organization; ERROR: parser: parse error at or near "orgname" foo=> select orgname::char from organization; ERROR: function char(varchar) does not exist I must be doing something really silly but I just don't see it. Any suggestions? TIA < Note: Redhat Linux 5.2 postgreSQL 6.3.2 > -Andrew adouglas@bellsouth.net � ---------------------------------------------------------------------------- Access your e-mail anywhere, at any time. Get your FREE BellSouth Web Mail account today! http://webmail.bellsouth.net ----------------------------------------------------------------------------
В списке pgsql-sql по дате отправления: