On Thu, Mar 02, 2006 at 02:33:08PM -0800, Davidson, Robert wrote:
> I would like to use daylight savings time aware time zones to
> display dates, but can't seem to get them to work no matter what
> alias I use:
>
> select '2005-02-25 00:00:00 -800' AT TIME ZONE 'CST6CDT' as interval
> ...
> ERROR
"Josh Berkus" <[EMAIL PROTECTED]> writes:
>> -- use labels to name columns in this way
>>
>> ... select col1 userid, col2 name from ... (instead of using AS)
> Because AS is the ANSI SQL 92 standard. And we like standards.
Actually, SQL92 says that AS is optional. However, Postgres contains
Mounir,
> -- do a join between two databases within the same installation.
>
> ... where db1.table1.userid = db2.table2.userid
Because this is not supported on PostgreSQL. There are a number of
reasons, and it may never be supported because there are drawbacks to
allowing databases to referen
