Questions tagged [identifier]
The identifier tag has no usage guidance.
10
questions
-2
votes
1answer
15 views
Does resetting table ids impact any performance? [closed]
When you have a high number of ids, but they aren't used anymore. Should you reset the id of the table? And does it have any performance difference?
0
votes
1answer
60 views
ORA-00904 invalid identifer error when using alias
I'm trying to return a product of two subqueries, and thought I'd make life easier by aliasing each of the subqueries, then divide the two aliases to get the number I'm after, like this:
select ...
-1
votes
1answer
4k views
Identifier that starts with is too long. Max length is 128
I referenced a few other blogs and I can't isolate the issue to this logic.
Code is below. Throws the error message attached.
-- 1. Import Multiple Delimited Text Files into a SQL ...
1
vote
1answer
2k views
Relation does not exist while scanning schema
My Postgres database is getting slow while executing some function. But another database of identical design and with more data is much faster than the first one. I have recently migrated data from MS ...
7
votes
5answers
11k views
Why can't object names start with a number?
For example, if I'm creating view with a name '4aii', why does SQL Server care that it starts with a 4? I could call the table Fouraii or IVaii.
Additionally, what does [] do behind the scenes to ...
2
votes
1answer
194 views
Does the SQL-1992 standard restrict naming identifiers to 18 characters?
In this draft of SQL:1992, I found…
Section 5.2
Leveling Rules
....
The following restrictions apply for Entry SQL in addition to any Intermediate SQL restrictions:
a) No <...
1
vote
1answer
2k views
How do I adopt the PostgreSQL naming convention in legacy database?
I realize I'll need to update the queries, but if I have a database that has camelCase or spaces in it, you have to use double quotes on the identifiers (viz. schema, table, column). How do I migrate ...
3
votes
1answer
307 views
Test if a string is a valid, unquoted identifier?
I'm just wondering if there is an established method for testing if a string can be used as an unquoted PostgreSQL identifier? (unquoted because almost any string can be a quoted identifier).
I ask ...
4
votes
2answers
2k views
Does this regex reliably remove square brackets from T-SQL?
I'm using SQL Server Management Studio 17.4, which supports search-and-replace using a Microsoft version of regular expressions (regex).
I need a regex expression that can reliably remove square ...
1
vote
1answer
147 views
What do we call the equivalent of CSS “Specificity” in SQL?
In CSS, the more HTML elements you specify, the more precedence the selector gets. This is known as "specificity." For example,
div p span {...}
Is more specific than, and thus would override:
span ...
