Re: Character translation?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Character translation?
Дата
Msg-id 20020909083627.P13345-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Character translation?  ("Linn Kubler" <lkubler@ecw2.org>)
Список pgsql-sql
On Thu, 5 Sep 2002, Linn Kubler wrote:

> Hi,
>
> I have a view like this:
> create view myview as
> select recid, title, firstname || chr(32) || lastname as expert, rank
>   from mytable;
>
> When I use this view via odbc on a Windows 2000 system using Visual FoxPro
> the expert field shows up as a memo field.  This is analogous to the text
> field in PSQL.
>
> What I'd like to do is have the expert column come through as a varchar type
> so that it shows up as a text field in VFP.  Any suggestions?
>
> I was looking at the functions and didn't see anything that would do the
> trick for me but I could have just missed something.  I also saw a reference
> to the cast() function but couldn't find any usage info on it in the online
> docs.

cast() isn't a function precisely speaking.  It works as
CAST(expr as datatype).




В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Database joins
Следующее
От: Masaru Sugawara
Дата:
Сообщение: Re: the best way to get the topest 3 record in every group