Getting an error when trying to use postgres typeorm Raw method

Question

can anyone help me with this?

I'm having a error when trying to search in postgres with typeorm. I'm trying to pass a Raw where, but I'm getting the following error:

{
  "error": "column \"mm\" does not exist"
}

This is my code where I use Raw:

const appointments = await this.ormRepository.find({
    where: {
        date: Raw(
            dateFieldName =>
            `to_char(${dateFieldName}, MM-YYYY) = '${parsedMonth}-${year}'`,
        ),
    },
});

Thanks so much!

Connor Low · Accepted Answer · 2021-05-21 22:40:26Z

1

You have a typo: you've told Postgres that MM is a column (thus the error). Instead of MM-YYYY, use 'MM-YYYY'.

answered May 21, 2021 at 22:40

Connor Low

7,4143 gold badges39 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Arthur Oliveira Over a year ago

Thanks so much man, it really solve my problem, I'm following a course and they use it without the quotes, maybe this changed!

Connor Low Over a year ago

I doubt the syntax changed: I guessing your course writers made a mistake. Wouldn't be the first time!

Collectives™ on Stack Overflow

Getting an error when trying to use postgres typeorm Raw method

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related