Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: Re: Re: Test for number or string

by nedals (Deacon)
on May 03, 2003 at 00:51 UTC ( [id://255208]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Test for number or string
in thread Test for number or string

In the former case, you should be able to determine the type of the field from the table schema.
I could indeed do that (see below) but I was trying to simplify things. I tried INSERTing into the database without the quotes and it would not save the data. I do understand your point regarding Perl's handling of strings and numbers.

Replies are listed 'Best First'.
Re: Re: Re: Re: Test for number or string
by ctilmes (Vicar) on May 03, 2003 at 01:01 UTC
    PostgreSQL is nice in that you can put quotes even if you are inserting a number.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://255208]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (5)
As of 2024-04-23 17:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found