10-28-2010
thanks...
this is working...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How can I do a case insensitive locate? (3 Replies)
Discussion started by: davis.ml
3 Replies
2. Shell Programming and Scripting
can I tell awk to be case insensitive for one operation without setting the ignorecase value ?
thanks,
Steffen (7 Replies)
Discussion started by: forever_49ers
7 Replies
3. Shell Programming and Scripting
hi everyone,
I need to do the following thing in a case insesitive mode
sed 's/work/job/g' filename
since work could appear in different form as Work WORK WorK wORK,....
I was wondering if i could do a case insensitive search of a word.
thanks in advance,
:) (4 Replies)
Discussion started by: ROOZ
4 Replies
4. Shell Programming and Scripting
I'd like to print a line if a substring is matched in a case insensitive manner
something like do a case insensitive search for ABCD as a substring:
awk '{ if (substr($1,1,4) == "") print $1 }' infile > outfile
I'm not certain how to make the syntax work???
Thanks (4 Replies)
Discussion started by: dcfargo
4 Replies
5. Shell Programming and Scripting
Hi All,
How we can perform case-insensitive search with AWK.:rolleyes:
regards,
Sam (11 Replies)
Discussion started by: sam25
11 Replies
6. Shell Programming and Scripting
Hey , i am trying to do a search for the certain books , and im trying to make it case insensitive. what i have come up with so far is this :
Database.txt
RETARDED MONKEY:RACHEAL ABRAHAML:30:30:20
GOLD:FATIN:23.20:12:3
STUPID:JERLYN:20:40:3
echo -n "Title: "
read Title
echo -n... (3 Replies)
Discussion started by: gregarion
3 Replies
7. UNIX for Dummies Questions & Answers
Hello,
How do I set case insensitive search mode while the file is open with more command ?
(I know -i option which could be used before opening)
thanks
Vilius (2 Replies)
Discussion started by: vilius
2 Replies
8. Shell Programming and Scripting
here is a statement
awk '/CREATE PROCEDURE/,/elimiter/' "$file1" > onlyproc1.sql
which mean cut from create procedure to Delimiter or delimiter and paste it in onlyproc1.sql... my query is how to make this case insensitive.. that is i want the above code to work whther it is Delimiter or... (26 Replies)
Discussion started by: vivek d r
26 Replies
9. Shell Programming and Scripting
I am trying to find case insensitive file names and then replace that particular file with other name.
if
then
ls | grep -i "update" | xargs -I {} mv {} LineItems.csv
echo "File moved from *update*"
elif
then
ls | grep -i "priority" | xargs -I {} mv {} ... (1 Reply)
Discussion started by: ATWC
1 Replies
10. UNIX for Beginners Questions & Answers
Dears,
In the below string, please let me know how to make the sed search case-incensitive. I have more such lines in my script instead of let me know any other easier option.
sed -n '/dn: MSISDN=/,/^\s*$/p' full.ldif > temp ; sed -n... (4 Replies)
Discussion started by: Kamesh G
4 Replies
PG_QUERY(3) PG_QUERY(3)
pg_query - Execute a query
SYNOPSIS
resource pg_query ([resource $connection], string $query)
DESCRIPTION
pg_query(3) executes the $query on the specified database $connection. pg_query_params(3) should be preferred in most cases.
If an error occurs, and FALSE is returned, details of the error can be retrieved using the pg_last_error(3) function if the connection is
valid.
Note
Although $connection can be omitted, it is not recommended, since it can be the cause of hard to find bugs in scripts.
Note
This function used to be called pg_exec(3). pg_exec(3) is still available for compatibility reasons, but users are encouraged to
use the newer name.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $query
- The SQL statement or statements to be executed. When multiple statements are passed to the function, they are automatically exe-
cuted as one transaction, unless there are explicit BEGIN/COMMIT commands included in the query string. However, using multiple
transactions in one function call is not recommended.
Warning
String interpolation of user-supplied data is extremely dangerous and is likely to lead to SQL injection vulnerabilities. In
most cases pg_query_params(3) should be preferred, passing user-supplied values as parameters rather than substituting them
into the query string.
Any user-supplied data substituted directly into a query string should be properly escaped.
RETURN VALUES
A query result resource on success or FALSE on failure.
EXAMPLES
Example #1
pg_query(3) example
<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occurred.
";
exit;
}
$result = pg_query($conn, "SELECT author, email FROM authors");
if (!$result) {
echo "An error occurred.
";
exit;
}
while ($row = pg_fetch_row($result)) {
echo "Author: $row[0] E-mail: $row[1]";
echo "<br />
";
}
?>
Example #2
Using pg_query(3) with multiple statements
<?php
$conn = pg_pconnect("dbname=publisher");
// these statements will be executed as one transaction
$query = "UPDATE authors SET author=UPPER(author) WHERE id=1;";
$query .= "UPDATE authors SET author=LOWER(author) WHERE id=2;";
$query .= "UPDATE authors SET author=NULL WHERE id=3;";
pg_query($conn, $query);
?>
SEE ALSO
pg_connect(3), pg_pconnect(3), pg_fetch_array(3), pg_fetch_object(3), pg_num_rows(3), pg_affected_rows(3).
PHP Documentation Group PG_QUERY(3)