Hello All,
Why not exists functions for convert any type to text?
I can't find text(bool), text(numeric) ...
May be it posiible in 7.2?
Victor
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(s
On Wed, 2001-11-28 at 11:24, Vicktor wrote:
> Why not exists functions for convert any type to text?
> I can't find text(bool), text(numeric) ...
use type casting:
select column::text from table
after :: comes the type you want.
Markus Bertheau
msg03163/pgp0.pgp
Description: PGP s
On 28 Nov 2001 12:00:44 +0100
Markus Bertheau <[EMAIL PROTECTED]> wrote:
It's not work when column is bool or numeric type !
> On Wed, 2001-11-28 at 11:24, Vicktor wrote:
> > Why not exists functions for convert any type to text?
> > I can't find text(bool), text(numeric) ...
>
> use type cas
Hi,
I am using the PGLIB C lib to connect to PgSql to finish
the update of the GEOMETRY of a table.At first, everything is OK. I
can insert, update, delete and select of whatever I want. However, I
got a fatal running error. There is an error when my SQL string length
exceeds 8190 Bytes. O
On Tue, 2001-11-27 at 16:39, TONY J.Y. wrote:
> However, I got a fatal running error. There is an error when my SQL
> string length exceeds 8190 Bytes.
PostgreSQL 7.0.x and earlier have a restriction of 8k for a text field.
7.1.x doesn't. You should upgrade.
Markus Bertheau
msg03166/pgp00
On Wed, 28 Nov 2001, Vicktor wrote:
> Hello All,
>
> Why not exists functions for convert any type to text?
> I can't find text(bool), text(numeric) ...
> May be it posiible in 7.2?
Don't think so. You need those functions and noone has written
them officially.
The former is easy, something
On Wed, 28 Nov 2001 08:35:00 -0800 (PST)
Stephan Szabo <[EMAIL PROTECTED]> wrote:
Ok, thank !
Vicktor
> On Wed, 28 Nov 2001, Vicktor wrote:
>
> > Hello All,
> >
> > Why not exists functions for convert any type to text?
> > I can't find text(bool), text(numeric) ...
> > May be it posiible
Vicktor writes:
> Why not exists functions for convert any type to text?
> I can't find text(bool), text(numeric) ...
Just because *some* mapping between data types exists it doesn't mean it's
the sound, well-defined, be-all-end-all. For instance, one might think
that TRUE => 't' and FALSE =>
On Wed, Nov 28, 2001 at 12:00:44PM +0100, Markus Bertheau wrote:
> On Wed, 2001-11-28 at 11:24, Vicktor wrote:
> > Why not exists functions for convert any type to text?
> > I can't find text(bool), text(numeric) ...
>
> use type casting:
>
> select column::text from table
>
> after :: comes
