Re: REFERENCES error message complaint, suggestion - Mailing list pgsql-general

From Chris Boget
Subject Re: REFERENCES error message complaint, suggestion
Date
Msg-id 024001c402ca$16aaacf0$8c01a8c0@entropy
Whole thread Raw
In response to REFERENCES error message complaint, suggestion  ("Karl O. Pinc" <kop@meme.com>)
Responses Re: REFERENCES error message complaint, suggestion
List pgsql-general
> How can they have no distinction?  Suppose I write
> select 'col' from tab;
> select "col" from tab;
> If there is a column tab.col, what am I going to get in each case?

select 'col' from tab;

+-----+
| col |
+-----+
| col |
| col |
| col |
+-----+
3 rows found in set (0.00 sec)

select "col" from tab;
+-----+
| col |
+-----+
| col |
| col |
| col |
+-----+
3 rows found in set (0.00 sec)

MySQL is definitely *not* 100% SQL92 compliant.

Chris






pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Trigger Update Issue
Next
From: Shridhar Daithankar
Date:
Subject: PHP on slackware