05-18-2005
thanks!!
but i want to get only one row at a time.......
i ahve a query like this
select column1 from table where something = column2
so i ahve to read row by row and substitute in colmun1 and column2
Thanks
Regards
vivek
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Freinds, :b:
i have a flat file with below format...
1234,Hary,102.55
4567,Maria,250.40
78942,suzan,261.60
48965,Harun,179.32
so I need a script that can get me as below format...
1) 1234,Hary,103
2) 4567,Maria,250
3) 78942,suzan,262
4) 48965,Harun,179
Which means, it... (6 Replies)
Discussion started by: malcomex999
6 Replies
2. Shell Programming and Scripting
Hi all, see i have a script that takes few arguments. first one is command we do on file, next is file (mostly txt file with lot of data) third is destination where we do something with data in file. Since im new in scripting, and im learning as i go, i need some hint how to manipulate that... (3 Replies)
Discussion started by: ajemrunner
3 Replies
3. Shell Programming and Scripting
OK, so if $0 represent the entire record... can I change $2 and will that be reflected back in $0?
I think the following answers that YES, it does work. But is there anything I should be thinking about prior to doing this? What I am actually doing is part of 5 pages of scripting and awk... (1 Reply)
Discussion started by: joeyg
1 Replies
4. Shell Programming and Scripting
I have a requirement like this:
I have modified versions of certain internal/external commands that I am putting into some directory say /mydir.
All the users will go an authentication check once they log in and based on the outcome there are two possibilities:
1. User passes... (12 Replies)
Discussion started by: ramesh_samane
12 Replies
5. UNIX for Dummies Questions & Answers
Hello Unix.com,
I have a text in format:
john
sara
lee
How can I make it:
john:john
john:john1
john:john12
john:john123
sara:sara
sara:sara12
sara:sara123 and so on (2 Replies)
Discussion started by: galford
2 Replies
6. UNIX for Dummies Questions & Answers
Hello unix.com users,
I have a ip file (line-by-line). How can I delete the ips that keep repeating by mark XXX.XXX.XXX.* ... I want to erase only the lines that keep repeating more than 2 times.
Example:
1.2.3.1
1.2.3.2
1.2.3.3
I want to erase all ips blocks that are repeating by C... (1 Reply)
Discussion started by: galford
1 Replies
7. UNIX for Dummies Questions & Answers
I have a list of file names, such as below
n02-z30-dsr65-terr0.50-dc0.002-8x6drw-csq.msf
n02-z30-dsr65-terr0.50-dc0.006-8x6drw-csq.msf
n02-z30-dsr65-terr0.50-dc0.010-8x6drw-csq.msf
n02-z30-dsr65-terr0.50-dc0.004-8x6drw-csq.msf
n02-z30-dsr65-terr0.50-dc0.008-8x6drw-csq.msf
I want to... (11 Replies)
Discussion started by: kristinu
11 Replies
8. Shell Programming and Scripting
I want to do the next
"I don't want to go school
because I'm sick today."
I want to join these two line but only when the first line is not more than 20 characters
and ended whit nothing or a comma and the second line not more than 15.
The 20 and the 15 can be change in the script.
I know... (10 Replies)
Discussion started by: thailand
10 Replies
9. Shell Programming and Scripting
Hello
Could you help with small script:
How to split string X1 into 3 string
String X1 can have 1 or many strings
X1='A1:B1:C1:D1:A2:B2:C2:D2:A3:B3:C3:D3'
This is output which I want to have:
Z1='A1:B1:C1:D1'
Z2='A2:B2:C2:D2'
Z3='A3:B3:C3:D3' (5 Replies)
Discussion started by: vikus
5 Replies
10. Shell Programming and Scripting
Hi,
I want to update the file with a value at a particular position
$cat test.txt
COL1=TEST
COL2=
COL3=AADSDFSDFDSFDFDF
I want to update the file with a value for COL2.
After update, the file should be like this
$cat test.txt
COL1=TEST
COL2=1
COL3=AADSDFSDFDSFDFDF
here 1... (9 Replies)
Discussion started by: vedanta
9 Replies
LEARN ABOUT CENTOS
spi_modifytuple
SPI_MODIFYTUPLE(3) PostgreSQL 9.2.7 Documentation SPI_MODIFYTUPLE(3)
NAME
SPI_modifytuple - create a row by replacing selected fields of a given row
SYNOPSIS
HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, int ncols,
int * colnum, Datum * values, const char * nulls)
DESCRIPTION
SPI_modifytuple creates a new row by substituting new values for selected columns, copying the original row's columns at other positions.
The input row is not modified.
ARGUMENTS
Relation rel
Used only as the source of the row descriptor for the row. (Passing a relation rather than a row descriptor is a misfeature.)
HeapTuple row
row to be modified
int ncols
number of column numbers in the array colnum
int * colnum
array of the numbers of the columns that are to be changed (column numbers start at 1)
Datum * values
new values for the specified columns
const char * Nulls
which new values are null, if any (see SPI_execute_plan for the format)
RETURN VALUE
new row with modifications, allocated in the upper executor context; NULL only if row is NULL
On error, SPI_result is set as follows:
SPI_ERROR_ARGUMENT
if rel is NULL, or if row is NULL, or if ncols is less than or equal to 0, or if colnum is NULL, or if values is NULL.
SPI_ERROR_NOATTRIBUTE
if colnum contains an invalid column number (less than or equal to 0 or greater than the number of column in row)
PostgreSQL 9.2.7 2014-02-17 SPI_MODIFYTUPLE(3)