8 More Discussions You Might Find Interesting
1. High Performance Computing
I am managing a linux cluster which has been build on Platform Cluster Manager PCM 1.2.1) from IBM Platform Computing. Unfortunately somebody deteled data files of postgresql from /var/lib directory. I somehow managed to start the postmaster service again, but all the administrative commands of... (2 Replies)
Discussion started by: ahsanpmd
2 Replies
2. Shell Programming and Scripting
I have 7 functions those need to be executed as command line inputs, I tried with below code it’s not executing function. If I run the ./script 2 then fun2 should execute , how to initiate that function I tried case and if else also, how to initiate function from command line
if
then... (8 Replies)
Discussion started by: saku
8 Replies
3. Solaris
Hi all,
I want to install two postgreql 8.3.5 instances on same servers. already one instalce is running on default port and i need it to be installed on another port.. How ever i achived installing the second instance.. but the problem is if i create a new user using createuser in the newly... (3 Replies)
Discussion started by: phani4u
3 Replies
4. UNIX and Linux Applications
I am trying to run vacuumdb script. but it exits with an error:
"ld.so.1: vacuumdb:fatal libpq.so.5 open failed no such file or directory"
same error is with some other pstgre commands.
please, help.
thanks.
edit: it seems I need to set LD_LIBRARY_PATH properly. but how to add to it?... (0 Replies)
Discussion started by: orange47
0 Replies
5. Solaris
I need to find out if a version of PostgreSQL installed in SPARC Solaris is > 7.2
please tell me how to do it.
thanks. (4 Replies)
Discussion started by: orange47
4 Replies
6. UNIX for Dummies Questions & Answers
I am first year year student .. and i need help
i tried to work with PostgreSQL but when i open the terminal, i face problem in how to reach to PostgreSQL . always i get message it says that " can not find server " .
so what shall i do please .....:( (9 Replies)
Discussion started by: barlom
9 Replies
7. Programming
Hi guys.
I was was designing a simple database in postgresql. I wrote a perl function in postgresql and execute it. suddenly i saw that it is running in an infinite loop. After i stopped executing of the query, i saw that CPU is in 90%+ load. I looked at process list and there it was. postgresql... (1 Reply)
Discussion started by: majid.merkava
1 Replies
8. Programming
Hi,
In the course of my script i have to compare SYSDATE with the 15th of the current month:
if it is greater than i should set a variable date to 15th of the next month
if less than i should set it to the 15th of the current month.
In other words the question is how to set a date variable... (2 Replies)
Discussion started by: fmina
2 Replies
SQL::Statement::Term(3) User Contributed Perl Documentation SQL::Statement::Term(3)
NAME
SQL::Statement::Term - base class for all terms
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::Term->new( $owner );
# access the value of that term
$term->value( $eval );
DESCRIPTION
SQL::Statement::Term is an abstract base class providing the interface for all terms.
INHERITANCE
SQL::Statement::Term
METHODS
new
Instantiates new term and stores a weak reference to the owner.
value
Abstract method which will return the value of the term. Must be overridden by derived classes.
DESTROY
Destroys the term and undefines the weak reference to the owner.
NAME
SQL::Statement::ConstantTerm - term for constant values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ConstantTerm->new( $owner, 'foo' );
# access the value of that term - returns 'foo'
$term->value( $eval );
DESCRIPTION
SQL::Statement::ConstantTerm implements a term which will always return the same constant value.
INHERITANCE
SQL::Statement::ConstantTerm
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the constant to deliver and a weak reference to the owner.
value
Returns the specified constant.
NAME
SQL::Statement::ColumnValue - term for column values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ColumnValue->new( $owner, 'id' );
# access the value of that term - returns the value of the column 'id'
# of the currently active row in $eval
$term->value( $eval );
DESCRIPTION
SQL::Statement::ColumnValue implements a term which will return the specified column of the active row.
INHERITANCE
SQL::Statement::ColumnValue
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the column name to deliver and a weak reference to the owner.
value
Returns the specified column value.
AUTHOR AND COPYRIGHT
Copyright (c) 2009,2010 by Jens Rehsack: rehsackATcpan.org
All rights reserved.
You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
README file.
perl v5.12.1 2010-05-06 SQL::Statement::Term(3)