Skip site navigation (1) Skip section navigation (2)

Re: problem migratin from ms sql

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Bruno Depero <bruno(dot)depero(at)digicar(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem migratin from ms sql
Date: 2005-04-23 05:36:15
Message-ID: 20050423053614.GA96734@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, Apr 19, 2005 at 05:35:05PM +0200, Bruno Depero wrote:
>
> create table #mytable( title_id char(6), total_money_made money ) insert 
> into #mytable select title_id, total_money_made=sum( ytd_sales*price ) 
> from titles group by title_id select * from #mytable drop table #mytable
> 
> Of course odbc driver for postgresql reports a syntax error due to the 
> table name !

See "Identifiers and Key Words" in the "SQL Syntax" chapter of the
documentation, in particular the discussion of quoted identifiers.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2005-04-23 06:23:14
Subject: Re: Base type ...and array of base type
Previous:From: Michael FuhrDate: 2005-04-22 23:09:49
Subject: Re: [PHP] Re: SSL use

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group