EverSQL Database Performance Knowledge Base
Changing datatype of a key in a object
Database type:
I have some object that was returned from my database. When i build up my table, these are the dtypes that i declared:
- festivalId = BIGINT
- performanceId = BIGINT
- startTime = TIME
- endTime = TIME
When i wanted to extract some records with a specific performanceId, my query looks something like this:
SELECT performanceId, to_char(startTime, 'HH24MI') AS startTime, to_char(endTime, 'HH24MI') AS endTime FROM Performance WHERE festivalId = $1
And the entire result returned from postgresql was concated into an object.
Right now the problem is that my javascript for my middleware is reading each performanceId that is found in each object(meaning each unique performanceId) as a string instead of a integer type.
e.g. performanceId 1234567890 is printed out as "1234567890" instead of 1234567890.
Is there anyway that i can convert performanceId output as a integer?
I tried to convert it to a integer when doing my sql SELECT statement,
SELECT CAST(performanceId AS INTEGER) AS performanceId, to_char(startTime, 'HH24MI') AS startTime, to_char(endTime, 'HH24MI') AS endTime FROM Performance WHERE festivalId = $1
but i realise its different as there is a different acceptance range for INTEGER and BIGINT.
I don't know if my above post was misleading or not, so i decided to put some dummy output here:
This is the unintended output:
{
"result": [
{
"performanceid": "9999999999",
"starttime": "0900",
"endtime": "1200"
}
]
}
This is the expected output:
{
"result": [
{
"performanceid": 999999999,
"starttime": "0900",
"endtime": "1200"
}
]
}