On 26/05/2012 00:04, Andreas wrote:
> Hi,
>
> I'm not into comparing which DBMS is better as we all know ... kind of ...
> well ...
>
> I'd like to find ressources to look up how one can do X in MSSQL when one
> knows how it is done in PG's SQL and the other way around.
>
> regards
> Andreas
On 27/05/2012 04:46, F. BROUARD / SQLpro wrote:
>> It's a little out of date (I've been meaning to update it for about 2 years
>> now) and has some gaps, but try the Database Rosetta Stone.
>>
>> http://www.grantondata.com/community/dbrosettastone.html
>
> Very out of date...
Yep, agreed, as you
Tom Lane wrote:
=?utf-8?Q?=E5=B0=8F=E6=B3=A2_=E9=A1=BE?= <[EMAIL PROTECTED]> writes:
[ snip a lot of marketing for SQL Server ]
I think the part of this you need to pay attention to is
Of course, nothing is entirely free, and this reduction in space and
time come at the expense of
Ron Mayer wrote:
Grant Allen wrote:
...warehouse...DB2...IBM is seeing typical storage savings in the
40-60% range
Sounds about the same as what compressing file systems claim:
http://opensolaris.org/os/community/zfs/whatis/
"ZFS provides built-in compression. In addition to
red
Hi Raymond,
From a strictly relational viewpoint, this is as easy as
(select users.uid, apps.appcode from apps, users)
except
(select canaccess.uid, canaccess.appcode from canaccess)
In english, that's the cartesian product of all users' uid and apps appcode
minus the known set of user+app a
Mark Roberts wrote:
- It'd be nice if the query planner was more "stable" - sometimes the
queries run fast, and then sometimes they randomly take 2 hours for a
delete that normally runs in a couple of minutes.
I was going to stay silent, because my pet peeves were already covered or had been f
Scott Marlowe wrote:
On Mon, Mar 9, 2009 at 2:55 PM, Paul Vercellotti wrote:
Hi there,
I hope this hasn't been covered in FAQ's; I couldn't find it specifically
mentioned. So we'd like to build a single-user application that uses
PostgreSQL as a database back end because of so many of the uni
inions only
If swallowed seek medical advice
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 30 December 2003 15:09
> To: Grant Allen
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Any way to disable backslash as a
> string li
> -Original Message-
> From: Shachar Shemesh [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 25 March 2004 05:39
> To: Grant Allen
> Cc: [EMAIL PROTECTED]; PostgreSQL OLE DB development;
> [EMAIL PROTECTED]
> Subject: Re: [GENERAL] ole db
>
>
> Grant Allen wr