Re: [SQL] type conversions

Hi Baris,
Think i found something for you. In pg_proc (a table you can and querry
in any postgres database - try "select * from pg_proc) i found the
following :

float4_text accepts float4 returns text
float8_text    float8        text
int2_text    int2        text
int4_text    int4        text
int8_text    int8        text
text_float4    text        float4
text_float8    text        float8
text_int2......    .    .
I think all these functions work with the argument between brackets ()
as any function in (almost) any language, but haven't tested them yet
though.

If You run into problems with fonctions or procedures, you should look
at this table, as well as at the pg_operator table. They are very
instructive, and speak for themselves, with some assumptions :-)

Hope it helps,

regards from Walter De Moudt
(sorry for the sloppy layout, had a drink tonight :-s)

Baris Ulu wrote:
> 
>         I created a function that returns a character which is
> concatanated with four or five different attributes, but one of them is
> float8 that indicates a ratio; but I hava not found a function that
> converts a floating point number to a text or char data type.  What can I
> do with it(Itried to convert it as in the following 'text(int(ratio))' but
> it gives the rounded integer value of my ratio as usual...)
> 
> ************