Enclose the IP in single quotes.
insert into ip values ('10.20.30.40');
------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it
as hoping to avoid that
necessity. I believe an initdb would replace pg_database so the system
wouldn't be able to see my db's, so I've been reluctant to do that. Any
thoughts are appreciated.
------
Aaron Holtz
Com
rging the two db's won't be anything easy, so I'm looking for a way for
this type of query to be valid.
------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email: [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--
Maybe not the fastest, but:
select some_field from table where lower(another_field) like
lower('%substring_entered_by_user%');
That will lower case the search field and item to do the match against.
------
A
us as to whether psql
didn't support this type of command or decided that a better way existed
to write the query. Thanks to all for the thoughts and ideas. Maybe this
support will be added at some juncture.
------
Aaron Ho
----
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email: [EMAIL PROTECTED]
"It's not broken, it just lacks duct tape."
--
On Apr 28, Oleg Broytmann molded the electrons to say....
>On Wed, 28 Apr 1999
Anyone know what could be causing this? The same
process inserts the data into the db and inspecting a flat file of the
outputted data shows no indication that the entries are different.
Any thoughts or pointers would be appreciated.
--------