Thanks everyone :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jorge Godoy
Sent: Friday, May 05, 2006 2:52 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Returning String as Integer
Em Sexta 05 Maio 2006 18:37, Kashmira Patel (kupatel) escreveu:
Here is a Perl function a friend of mine wrote to help with this...
Problems I ran into were errors because of NON NUMERIC Characters in the
String...
Casting would fail
It doesn't catch all cases but it has been quite helpful to me
$x = $_[0];
$x =~ s/^[^-\d\.]*//;
$x =~ s/\,//g;
$x = $x * 1;
Use the to_number() function to convert text to numbers.
In the manual under functions and operators. The other
function like it is to_date().
--elein
[EMAIL PROTECTED]
On Fri, May 05, 2006 at 02:37:13PM -0700, Kashmira Patel (kupatel) wrote:
> Hi all,
>I have a table with a column of type '
Em Sexta 05 Maio 2006 18:37, Kashmira Patel (kupatel) escreveu:
> Hi all,
>I have a table with a column of type 'text'. It mainly contains
> numbers. Is there any way to select a value from this column and return
> it as an integer?
testing=# select '123'::integer;
int4
--
123
(1 regis
Hi
all,
I have
a table with a column of type 'text'. It mainly contains numbers. Is there any
way to select a value from this column and return it as an
integer?
Thanks,
Kashmira
Hi, Fay,
Fay Du wrote:
> I would like to put some message in my C function ( myTestFunction).
> Currently, I want to see time for each function call inside
> myTestFunction. The output to the screen commands are in myTestFunction.
> myTestFunction is called from postgresql. How can I see the
