From: Richard Huxton <dev@archonet.com>
To: Linn Kubler <lkubler@ecw2.org>
To: pgsql-sql@postgresql.org
Subject: Re: Character translation?
Date: Mon, 9 Sep 2002 15:50:07 +0100
Message-ID: <200209091550.07630.dev@archonet.com> (raw)
In-Reply-To: <al8l13$48u$1@news.hub.org>
References: <al8l13$48u$1@news.hub.org>
On Thursday 05 Sep 2002 11:15 pm, 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.
I think you're on the right track, try something like:
select (firstname || ' ' || lastname)::varchar as expert ...
If it works, could you let the list know in case anyone else needs this in
future. If not, there is an ODBC list too (see postgresql.org website for
details)
- Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, lkubler@ecw2.org
Subject: Re: Character translation?
In-Reply-To: <200209091550.07630.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox