SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Joe Celko / Stairway to SQL Dialects Level 2: Postgres / Latest Posts

RE: Stairway to SQL Dialects Level 2: Postgres

Milos Babic — Wed, 14 Nov 2012 07:29:29 GMT

actually, porting FROM commercial DB solution to PostgreSQL is not uncommon if you have a product and you want to lower its overall cost.

RE: Stairway to SQL Dialects Level 2: Postgres

Meow Now — Wed, 14 Nov 2012 07:09:34 GMT

Interesting article. I've only been working with databases for about 10 years, but I have only seen porting to SQL Server from Postgres. Never the other way around. It's rare for a company to go away from the Microsoft platform once they've already made a major investment which generally involves multiple products and support agreements.

RE: Stairway to SQL Dialects Level 2: Postgres

Milos Babic — Wed, 14 Nov 2012 04:12:16 GMT

SQL Server's "READ_COMMITTED_SNAPSHOT" isolation level overcomes different concurrency control and it is closest to Postgres' MVCC.

RE: Stairway to SQL Dialects Level 2: Postgres

GurjeetSingh — Mon, 24 Sep 2012 15:09:40 GMT

Just adding a couple more corrections, after what Richard noted earlier.Postgres also has a BIGINT data type which is exactly 8 bytes wide.SQL Server's IDENTIY column may be better mapped to SERIAL pseudo data type, which is a combination of INT DEFAULT NEXTVAL(). There's also BIGSERIAL which user BIGINT under the covers.Postgres' BOOLEAN data type [i]does[/i] support NULL values.[quote]You cannot create a temp table with column declarations but only with a query[/quote]I am not sure what you implied by the above statement, but one can create a temporary table in Postgres without having to use a query at the same time:[code]CREATE TEMPORARY TABLE test( a INT );[/code]- Gurjeet

RE: Stairway to SQL Dialects Level 2: Postgres

rbroersma — Fri, 21 Sep 2012 13:26:06 GMT

[quote] Other Data Types... Does not support NULL values.[/quote]I think this statement may need clarification:[code="sql"]Microsoft Windows XP [Version 5.1.2600](C) Copyright 1985-2001 Microsoft Corp.C:\Documents and Settings\rbroersma>psqlPassword:psql (9.2.0)WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details.Type "help" for help.rbroersma=> SELECT CAST( TRUE AS Boolean ) AS "True", CAST( FALSE AS Boolean) AS "False", CAST( NULL AS Boolean) AS "Null"; True | False | Null------+-------+------ t | f |(1 row)rbroersma=>[/code]Also, [quote] Temp Tables... You cannot create a temp table with column declarations but only with a query. ...Here is the syntax:CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] [ [ WITH | WITHOUT ] OIDS ] AS query DML in Postgres [/quote][code="sql"]rbroersma=> CREATE TEMPORARY TABLE Testtable ( foo INTEGER, bar CHARACTER VARYING, baz TIMESTAMP WITHOUT TIME ZONE );CREATE TABLErbroersma=>[/code]

Stairway to SQL Dialects Level 2: Postgres

CELKO — Thu, 10 May 2012 08:43:43 GMT

Comments posted to this topic are about the item [B]Stairway to SQL Dialects Level 2: Postgres[/B]