Olivier Guimbal comments

Results 116 comments of


                                            Olivier Guimbal

Support for LIKE ... INCLUDING ALL

For my information: Which kind of retroactive edge cases are you refering to ? You mean edge cases with your specific use case leading you to change your model ?...

Error when using window function

Hi ! Thanks for the report (and sorry for the late reply). "OVER" keyword is not supported yet in pg-mem. It will come, but I cant give an ETA yet...

Error when using window function

thanks for the details

Alter the length of a varchar column throws Error: Corrupted alias

Hi ! Thanks for the report. Thanks for trying to fix that. I'm not sure why you get these errors (the error itself is kinda weird: I dont see how...

Implementation of ROW_NUMBER

Hi Rémi, Thanks ! Ouch... that not a simple function, so registerFunction() is not the right call here. This is quite tricky to implement. I dont have time to implement...

ERROR: function to_timestamp(unknown) does not exist

Hi ! You could declare multiple overloads of the same function like below. As a side note: Beware, it could work to return a moment instance because pg-mem also uses...

Support expressions like "SUBSTRING(a FROM b)"

Hey ! Sorry for the delay :) What is the error ? Thanks

Support expressions like "SUBSTRING(a FROM b)"

Okay thanks :)

Support expressions like "SUBSTRING(a FROM b)"

Hi, a workaround could be to create this function in your db: ```sql create function substring_from(str text, search text) returns text as $$ select substring(str from search) $$ language sql...

Include PSQL Error Codes in Execution Errors

That could be possible. Actually, I recently began including error messages matching actual pg errors + some details that pg usually provides. [See here for an example](https://github.com/oguimbal/pg-mem/blob/64364aca03ab68274d967ae27c8f751c5e8117c2/src/constraints/foreign-key.ts#L170-L174) I could also...