Segregated the problematic portion, and showing for your view here.,
1. Following is the function definition,
create or replace function new_del(id integer) returns void as $$
begin
raise info 'dollar :%',$1;
delete from testing where id=$1;
end ;
$$
language 'plpgsql';
... (1 Reply)
Hi All
I have what seems to be something quite trivial but for the life of me can't work out a solution.
Basically, I have the following script that reads a version report that contains certain flags. If a condition is true, I want to print the value of column 2, sort them uniquely and return... (2 Replies)
Hi,
I have installed cygwin on my windows XP system. And I am trying to use the following code snippet:
set SERVER="grep JDBCConnectionPool config.xml | gawk -F; '{print $2}'"
sed -i 's/%SERVER%/WLMDEVDB1/' config.xml
But it doesn't work because at runtime %SERVER% gets replaced by "grep... (2 Replies)
Well as the title describes, its a pretty straight forward problem. I have a series of psql tables where there are lots of blanks. However there is at least one column, called name, that will never be blank. I want to write a select statement to get all of the contents of the table and then turn... (3 Replies)
Hey All,
Quick question...
I'm writing a short script to check if a continuous port is running on a server.
I'm using "ps -ef | grep -v grep | grep processName" and I was wondering if it was better/more reliable to just check the
return code from the command or if its better to pipe to... (12 Replies)
Hi All,
There are 2 scripts A and B.
A --> It will invoke script B
B -->
It will generate below output.
100 - connected
105 - Not Connected
210 - Connected
I want to return this value to script A. Please advice. (4 Replies)
cmd()
{
echo " "
echo "$(whoami)@$(hostname):$(pwd)# $*"
results=`eval $*`
echo $results
}
I want to get the eval $* 's return value and pass it to a new variable $val, and get "eval $*" 's the ... (7 Replies)
Hello
Just edited the entry to make it easier to understand what i want
How can i achieve this: GOAL:
read 2 field from a table with PSQL
result of this PSQL command is this
INSTALLEDLANG=$(su - postgres -c "psql -A -t -q -c -d ${DBNAME} -t -c 'SELECT code, iso_code from res_lang'")
... (0 Replies)
Hi,
I have a shell script containing multiple PSQL queries for which I want the output to be redirected to a text file.
psql -U postgres -d database -o textfile.txt << EOF
Query1;
Query2;
Query ....;
EOF
When executing the script, queries outputs are directed to textfile.txt, however... (2 Replies)
Discussion started by: nms
2 Replies
LEARN ABOUT HPUX
cfsetospeed
cfspeed(3C)cfspeed(3C)NAME
cfgetospeed(), cfsetospeed(), cfgetispeed(), cfsetispeed() - tty baud rate functions
SYNOPSIS DESCRIPTION
These functions set and get the input and output speed codes in the termios structure referenced by termios_p. The termios structure con-
tains these speed codes representing input and output baud rates as well as other terminal related parameters. Setting the parameters on a
terminal file does not become effective until is successfully called.
returns the output speed code from the
termios structure referenced by termios_p.
sets the output speed code in the
termios structure referenced by termios_p to speed. The speed code for a baud rate of zero, is used to termi-
nate the connection. If is specified, the modem control lines are no longer asserted, which normally discon-
nects the line.
returns the input speed code from the
termios structure referenced by termios_p.
sets the input speed code in the
termios structure referenced by termios_p to speed.
RETURN VALUE
returns the output speed code from the termios structure referenced by termios_p.
returns the input speed code from the termios structure referenced by termios_p.
and return zero upon successful completion. Otherwise, they return -1 and set to indicate the error.
ERRORS
and fail when the following condition is encountered:
[EINVAL] The value of speed is outside the range of possible speed codes as specified in
WARNINGS
and can be used to set speed codes in the termios structure that are not supported by the terminal hardware.
SEE ALSO tcattribute(3C), thread_safety(5), termio(7).
STANDARDS CONFORMANCE cfspeed(3C)