Questions tagged [reserved-word]
The reserved-word tag has no usage guidance.
9 questions
9
votes
3
answers
2k
views
Is the keyword "ALIAS" actually used?
According to PostgreSQL 7.1 through 9.1 (now unsupported), ALIAS is listed as a reserved word, at least for SQL-99. Later versions do not show it - suggesting that it has been dropped as a reserved ...
- 182k
0
votes
1
answer
251
views
System-level way to enforce that reserved words may not be used for Oracle column names?
Is there a way in Oracle 12c to enforce that reserved words / keywords may not be used as column names? I am aware that it is not good practice to use keywords in this way. However from what we have ...
- 3,122
3
votes
4
answers
8k
views
MySQL similar name for status or type column
As status and type is reserved key in MySQL, I need a column name similar to status to identify the status of a row.
I know there is way to ignore this problem but in different language and different ...
CommunityBot
- 1
-1
votes
1
answer
462
views
Why would SQL queries that use reserved words suddenly start causing problems?
In the past couple of days we have experienced issues with 3 different applications that have been running fine for several years. Errors #1 and #2 were caused by reserved words in SQL queries. I am ...
- 16.2k
14
votes
1
answer
2k
views
Why is "Lookup" colored as a function reserved word in SQL Server?
In SSMS 2208, the identifier "Lookup" is colored hot pink as if it were a function (same color as, say, "Power" or "Convert"). Why?
I cannot find it in the official list of reserved words. Searches ...
- 121
3
votes
1
answer
3k
views
What problems would using the reserved keywords DATE and TIME as column names cause in Oracle?
DATE is an SQL Reserved Word and TIME is a PL/SQL Reserved Word in Oracle (listed in SQL> HELP RESERVED WORDS). What problems would using them as column names cause in Oracle?
The database server ...
- 31.9k
2
votes
1
answer
1k
views
trigger can't access column loop
SSCCE:
The following script:
$ cat test.sql
CREATE TABLE public.foo (
loop INTEGER
);
CREATE OR REPLACE FUNCTION public.foo_fun(loop INTEGER) RETURNS BOOLEAN AS $$
SELECT TRUE;
$$ LANGUAGE SQL;
...
- 182k
1
vote
1
answer
329
views
why is the name `loop` treated differently in PostgreSQL
I issue the following DDL:
CREATE TABLE foo
(
loopa INTEGER,
loop INTEGER
);
Then, examining the DDL in the server (using a client-side tool like DbVisualizer - sorry don't know the query to ...
CommunityBot
- 1
4
votes
1
answer
4k
views
What is the purpose of the keyword "ID" in PostgreSQL?
I'm new to PostgreSQL and I ran into problems using the following query:
SELECT * FROM table1 WHERE ID = 1
ERROR: column "id" does not exist
LINE 2: WHERE ID = 1
where ID is a column I added ...
