01-29-2013
NVL isn't supported with psql according to what I've read, but your example keyed me in on how to use coalesce. This did the trick.
SELECT name,date,coalesce(value,0) FROM table;
Regards,
Dave
This User Gave Thanks to wxornot For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
How to access the postgreSQL from a perl script?
Thanks in advance
JS (2 Replies)
Discussion started by: jisha
2 Replies
2. Shell Programming and Scripting
I have various column names within double quotes, separated by commas.
Example:
"column one", "column number two", "this is column number three", anothercolumn, yetanothercolumn
I need to eliminate the double quotes and replace the blanks within the double quotes by underscores, giving:
... (5 Replies)
Discussion started by: jgrogan
5 Replies
3. Shell Programming and Scripting
Can someone help me to write a script / command to read in a file, character by character, replace any unknown ASCII characters with space. then write out the file to a new filename/
Thanks! (1 Reply)
Discussion started by: raghav525
1 Replies
4. Shell Programming and Scripting
Hi Everyone,
When i finish running
# echo `psql -t -U root databaseA -c "select a, b from book"`;
i get the output
107275 | 14 107301 | 2 107446 | 6 107820 | 77 107929 | 101
Would like to have the result like:
107275 | 14
107301 | 2
107446 | 6
107820 | 77
107929 | 101 (7 Replies)
Discussion started by: jimmy_y
7 Replies
5. Shell Programming and Scripting
Hi All,
Was wondering how I can do the following....
I have a String as follows
"ACCTRL000005022RRWDKKEEDKDD...."
This string can be in a file called tail.out or in a Variable called $VAR2
Now I have another variable called $VAR1="000004785" (9 bytes long), I need the content of... (5 Replies)
Discussion started by: mohullah
5 Replies
6. Shell Programming and Scripting
Hello,
I'm trying to replace the first x number of spaces in a line with a |. Right now I'm using a very inefficient syntax to accomplish the task and was looking to simplify it.
I have several cases were the pipes need to replace just the first space on the line, which I did a simple... (11 Replies)
Discussion started by: bd_joy
11 Replies
7. Shell Programming and Scripting
Hi all,
Greetings,
I have the following scenario, The contents of main file are like :
Unix|||||forum|||||||||||||||is||||||the||best
so||||||be|||||on||||||||||||||||||||||||||||||||||||||||||||it
And i need the output in the following form:
Unix=forum=is=the=best
so=be=on=it
... (3 Replies)
Discussion started by: dipanchandra
3 Replies
8. Shell Programming and Scripting
Hi,
i want find the character '-' in a file from position 284-298, if it occurs i need to replace it with 'O ' for the position in the file. How to do that using SED command.
thanks in advance,
Sara (9 Replies)
Discussion started by: Sara183
9 Replies
9. UNIX for Advanced & Expert Users
hello
i have file with 100k records and each one has certain value that starts at 28th column and certain value that starts at 88th column
e.g. 1st file
<25>1234567 ..... <88> 8573785485
i have aditional file with values which are related to value that starts at 88th column of the... (1 Reply)
Discussion started by: dell1520
1 Replies
10. How to Post in the The UNIX and Linux Forums
Hi All,
I am trying to replace the values inside <password> tag in an xml file but it doesn't replace certain passwords:
For eg:
Server/home/sperinc>cat TextXML.txt
<appIds>
<entry name="AccountXref">
<type id="ldap">
<realm>nam</realm>
... (7 Replies)
Discussion started by: saroopkris85
7 Replies
lex(1) General Commands Manual lex(1)
Name
lex - generate lexical analyzer
Syntax
lex [-tvfn] file...
Description
The command generates programs to be used in simple lexical analysis of text. The input files (standard input default) contain regular
expressions to be searched for, and actions written in C to be executed when expressions are found.
A C source program, 'lex.yy.c', is generated. It is compiled using the following command line:
cc lex.yy.c -ll
This program copies unrecognized portions of the input to the output, and executes the associated C action for each regular expression that
is recognized.
Options
-f Runs a faster compilation (does not pack resulting tables). This is limited to small programs.
-n Prints no summary information (default option).
-t Writes to standard output instead of to file
-v Prints one-line summary of generated statistics.
Examples
In the following example, the command
lex lexcommands
draws instructions from the file lexcommands, and places the output in lex.yy.c. The command
%%
[A-Z] putchar(yytext[0]+'a'-'A');
[ ]+$
[ ]+ putchar(' ');
is an example of a program that would be put into a command file. This program converts upper case to lower, removes blanks at the end of
lines, and replaces multiple blanks by single blanks.
See Also
sed(1), yacc(1)
"LEX - Lexical Analyzer Generator", Supplementary Documents, Volume 2: Programmer
lex(1)