From: Troy <tjk@tksoft.com>
To: lkubler@ecw2.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Character translation?
Date: Mon, 9 Sep 2002 00:47:49 -0700 (PDT)
Message-ID: <200209090747.g897loST003822@tksoft.com> (raw)
In-Reply-To: <no.id>
Would this work?
select recid, title, firstname || chr(32) || lastname::char(50) as expert,
rank from mytable where length(lastname) <= 50;
Troy
>
> 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.
>
> Any help is greatly appreciated.
> Thanks in advance,
> Linn
>
>
> --
> Please remove the number two from domain name for email.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
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: tjk@tksoft.com, lkubler@ecw2.org
Subject: Re: Character translation?
In-Reply-To: <200209090747.g897loST003822@tksoft.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