From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
---|---|
To: | Robert Bernier <robert7390(at)comcast(dot)net> |
Cc: | pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: Nice Quote from Celko |
Date: | 2012-09-24 20:07:33 |
Message-ID: | 5060BD85.3020307@archidevsys.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2012-09-24 21:15:51 | Re: Nice Quote from Celko |
Previous Message | Josh Berkus | 2012-09-24 19:58:41 | Re: French Prime Minister loves PostgreSQL |