From: | paallen(at)attglobal(dot)net |
---|---|
To: | "Joel Richard" <postgres(at)joelrichard(dot)com>, pgsql-sql-owner(at)postgresql(dot)org, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "sql pgsql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Converting from MS Access field aliases |
Date: | 2007-07-12 18:07:49 |
Message-ID: | 1996625737-1184263783-cardhu_decombobulator_blackberry.rim.net-1685167243-@bxe119.bisx.prod.on.blackberry |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Joel,
To avoid ms access from managing the query, use a pass-through query. Then access will send the raw sql statment to psql and psql will return just the results to access.
It will speed things up a bit too for large datasets.
Phillip allen
Sent via BlackBerry by AT&T
-----Original Message-----
From: Joel Richard <postgres(at)joelrichard(dot)com>
Date: Thu, 12 Jul 2007 13:36:05
To:Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Converting from MS Access field aliases
On Jul 12, 2007, at 1:23 PM, Tom Lane wrote:
> chester c young <chestercyoung(at)yahoo(dot)com> writes:
>>> SELECT field1 / 2 AS foo,
>>> field2 * 2 AS bar,
>>> foo + bar AS total
>>> WHERE foo < 12;
>
>> First, I think it would be great if this worked - like the alias
>> to an
>> update table added in 8.2 - saves a lot of typing and makes queries
>> much more readable.
>
> This is not an "extension", it is *directly* contrary to both the
> letter
> and spirit of the SQL standard. I can hardly believe that M$ did that
> ... oh, actually, I can entirely believe it. The OP has a serious
> problem of vendor lockin now, and that's exactly what M$ wants.
>
> regards, tom lane
Hear hear!
What's really screwy is what I found when I hooked access into my
PostgreSQL database using pgsqlODBC (I know, it's an abomination) and
I logged the statements that PostgreSQL was processing. In MS Access
this query:
SELECT foo AS bar, bar * 2 AS gleep FROM table;
became this in PostgreSQL's logs
SELECT foo FROM table;
Vewwy Intewesting! I think Microsoft and ODBC might be making extra
work for themselves (obviously they are since they are allowing these
aliases) Or maybe not. Maybe I can glean something from this. Who knows.
--Joel
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Tauno Williams | 2007-07-12 20:34:10 | Re: Converting from MS Access field aliases |
Previous Message | Tom Lane | 2007-07-12 17:48:40 | Re: Converting from MS Access field aliases |