Re: Simple query question

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: <pgsql-novice(at)postgresql(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Simple query question
Date: 2002-12-23 18:20:01
Message-ID: 014a01c2aaaf$e9bcd2e0$4201a8c0@beeblebrox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> I can't believe that MySQL gets such a basic element of SQL syntax wrong
> --- perhaps the OP is mistaken? If MySQL really does treat doublequote
> as introducing a literal, how do they handle weird identifiers, like
> names with embedded spaces?

back-ticks...
SELECT * FROM `table name with spaces` WHERE `key`="a";

MySQL = My personal interpretation of SQL...

;-)

Regards,
Michael Paesold

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Manfred Koizar 2002-12-23 18:34:48 Re: Simple query question
Previous Message Tom Lane 2002-12-23 18:01:58 Re: Simple query question