mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: March 2008
http://mssql-to-postgresql.blogspot.com/2008_03_01_archive.html
MS SQL to PostgreSQL. Friday, March 28, 2008. NULL should be renamed to UNKNOWN. The following has no output when it should has:. Select * from src where n not in (select n from dst);. Create table src (n int);. Create table dst(n int);. Insert into src(n) values(1),(2),(3),(4),(5);. Insert into dst(n) values(1),(2),(3);. Select * from src where n not in (select n from dst); - lists 4, 5. Insert into dst(n) values(null);. Select * from src where n not in (select n from dst); - no output. NULL OR NULL res...
mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: July 2008
http://mssql-to-postgresql.blogspot.com/2008_07_01_archive.html
MS SQL to PostgreSQL. Monday, July 14, 2008. My first time to win computer chess (GNU Chess). Killing time from our Linux server this afternoon after i ate lunch :-D. My first time to win again against computer, also my first time to play GNU Chess (using normal settings) next time i'll try the difficult level. Posted by Michael I. Buen at 3:04 PM. Links to this post. Thursday, July 03, 2008. Simple rant: a CRUD day. I would use stored procs for reports. but for desktop app CRUD routines? 怎么办 (how to do?
mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: April 2008
http://mssql-to-postgresql.blogspot.com/2008_04_01_archive.html
MS SQL to PostgreSQL. Thursday, April 24, 2008. Though logically the same, this is easier to read:. Select CURRENT TIMESTAMP unlocked expiration. Where invoice rec id = 'value here'), true) as has expired. Where invoice rec id = 'value here'), true) as has expired. Posted by Michael I. Buen at 10:43 AM. Links to this post. Michael I. Buen. The opposite of neub. A Filipino programmer. View my complete profile. My first time to win computer chess (GNU Chess). Simple rant: a CRUD day.
mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: April 2006
http://mssql-to-postgresql.blogspot.com/2006_04_01_archive.html
MS SQL to PostgreSQL. Thursday, April 20, 2006. CREATE FUNCTION FormatterNumber(@i INT) RETURNS VARCHAR(100). RETURN CONVERT(VARCHAR, @i) ' Michael the INT'. PostgreSQL: Note postresql parameter can be also be referenced by their parameter number, e.g. $1, $2. We don't have to declare varchar(100) in returns clause,. It is adjusted dynamically. Method 1, this is flexible, can have multiple statements between begin and end. CREATE FUNCTION FormatterNumber(m I INT) RETURNS VARCHAR. Resulting to a more symm...
mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: December 2007
http://mssql-to-postgresql.blogspot.com/2007_12_01_archive.html
MS SQL to PostgreSQL. Monday, December 24, 2007. How to detect if field's value changes in UPDATE trigger. Use this approach if your field is NOT NULLable:. Raise notice 'something changes';. Use this approach if your field is NULLable: # is the XOR of Postgres. False xor false = false. False xor true = true. True xor false = true. True xor true = false. NEWfield is null): int # (OLD.field is null): int ) = 1. Raise notice 'something changes';. Posted by Michael I. Buen at 9:31 AM. Links to this post.
mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: August 2008
http://mssql-to-postgresql.blogspot.com/2008_08_01_archive.html
MS SQL to PostgreSQL. Tuesday, August 26, 2008. Export public key, - armor makes the key file ascii readable. Gpg - armor - export miblogic@gmail.com miblogic.gmail.public.key. Gpg -a - export miblogic@gmail.com miblogic.gmail.public.key. Gpg - armor - export-secret-key miblogic@gmail.com miblogic.gmail.private.key. Import the public key of miblogic@yahoo.com. Gpg - import miblogic.yahoo.public.key. Gpg a piped output:. Miblogic@yahoo.com decrypting a message from miblogic@gmail.com. Links to this post.
mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: July 2006
http://mssql-to-postgresql.blogspot.com/2006_07_01_archive.html
MS SQL to PostgreSQL. Wednesday, July 26, 2006. Alter PROCEDURE x Financing ExceedsDueDate. SET @DayToday = convert(DATETIME,CONvERT(vARCHAR,GETDATE(),112). XInvoiceNo, X.PmtStructureNo, Fullname = COALESCE(i.Fullname, m.FUllname),D.PayImmediately,. DaysExceed = DATEDIFF(DAY, BillStatementDate, @DayToday). LEFT JOIN AccountInstallment ION I.InvoiceNo = D.InvoiceNo. LEFT JOIN Financing AssumptionOfMortgage mON m.AoMNo = d.InvoiceNo. ALTER PROCEDURE Financing ExceedsDueDate. INNER JOIN ( SELECT InvoiceNo, ...
mssql-to-postgresql.blogspot.com
MS SQL to PostgreSQL: May 2006
http://mssql-to-postgresql.blogspot.com/2006_05_01_archive.html
MS SQL to PostgreSQL. Sunday, May 14, 2006. Slashdot Review: Matrix: Reloaded. About 12 people reproducing into 250,000 people so quickly: yes this is possible. if each woman produced as many children as could be done healthily, say 10, you could do it in 4 new generations:. 7 women * 10 children = 70 new ppl. 70 * 0.5 (50% girls) * 10 children = 350 new ppl. 350 *0.5 *10 = 1750 ppl. 8750 *0.5*10 = 43750 ppl. 218750 *0.5*10 = 218750 ppl. 12 70 350 1750 43750 218750. Tuesday, May 09, 2006. How to detect i...