Re: Nice Quote from Celko

From: Gavin Flower
Subject: Re: Nice Quote from Celko
Date: ,
Msg-id: 5060BD85.3020307@archidevsys.co.nz
(view: Whole thread, Raw)
In response to: Re: Nice Quote from Celko  (Robert Bernier)
Responses: Re: Nice Quote from Celko  (Thomas Kellerer)
List: pgsql-advocacy

Tree view

Nice Quote from Celko  (Richard Broersma, )
 Re: Nice Quote from Celko  (Richard Broersma, )
  Re: Nice Quote from Celko  (Thomas Kellerer, )
 Re: Nice Quote from Celko  (Gavin Flower, )
  Re: Nice Quote from Celko  (Robert Bernier, )
   Re: Nice Quote from Celko  (Gavin Flower, )
    Re: Nice Quote from Celko  (Thomas Kellerer, )
 Re: Nice Quote from Celko  (Robert Bernier, )
  Re: Nice Quote from Celko  (Gurjeet Singh, )

On 25/09/12 03:31, Robert Bernier wrote:
On Saturday, September 22, 2012 01:54:08 pm Gavin Flower wrote:
On 23/09/12 03:31, Richard Broersma wrote:
"Developers are more likely to port SQL Server to Postgres because it 
is open source, supports more ANSI features, runs on more platforms, 
uses a different ACID model and has a great optimizer. "

http://www.sqlservercentral.com/articles/Stairway+Series/89991/

It wanted me to login to read it.

Read it using elinks, that's what I did.


Robert
Thanks

I have not checked everything, but noted that..

It claims
"[...]
The model for temporary tables is weaker than T-SQL in some ways. ... You cannot create a temp table with column declarations, but only with a query..
[...]"

this obviously false:

CREATE TEMP TABLE tem_tab
(
    id      SERIAL PRIMARY KEY,
    payload text
);


INSERT INTO  tem_tab (payload)
VALUES
    ('first'),
    ('second'),
    ('third'),
    ('fourth'),
    ('fifth'),
    ('sixth'),
    ('seventh'),
    ('eighth');
   
SELECT * FROM tem_tab ORDER BY payload;


works in PostgreSQL

pgsql-advocacy by date:

From: Gavin Flower
Date:
Subject: Re: Nice Quote from Celko
From: Thomas Kellerer
Date:
Subject: Re: Nice Quote from Celko