I have a table where one of the columns is a library of congress number.
I would like to be able to ORDER BY this column.
Currently, the column is a varchar. Unfortunately, a normal string comparison
will not work.
First, has anyone done this already?
If not, I’m thinking I would need to:
1) define a new type to hold LOC numbers.
2) write a function that determines less than, greater than
It seems like I’m missing something here. I have not yet defined a new
type…is defining less/greater part of that process?
Is there a simpler way to do this?
Any advice is appreciated.