Postgresql about is the problem that the string in the between the and-CodePudding

Home > database > Postgresql about is the problem that the string in the between the and

Postgresql about is the problem that the string in the between the and

Time：12-25

There was a row in a table, icd9_code type is character varying (n), fixed maximum length of the string variable,
The SQL statement is:

 
Select * 
The from d_icd_diagnoses 
Where icd9_code between '7463' and '7466'

Please note: '7463' there is a space behind the location of the string,
I want to ask next, '7463' and '7463' is there a difference? Is' 7463 'query range is' 7463', '74630 -' 74639 '?
What's in between principle is like this? Explain,

Page link：https//www.codepudding.com/database/95989.html

Prev:How to write a SQL server timer function, such as proxy method except homework

Next:Consult how SQL Server thread pool under the application

Tags：

problems

Links：
CodePudding