Timeline for Problem with postgres Function
Current License: CC BY-SA 4.0
5 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Mar 14, 2021 at 15:08 | comment | added | Hedi Hadhri | It seems to not work =/ For example when I call the function like this 'select fied_summaries('5minutes', NULL:: m_13, 'current')' it executes but when I do 'select fied_summaries('5minutes', 'm_13', 'current')' it throws an error that m_13 does not exist. My goal is to call the function like that. Is there away to make the NULL::m_13 call inside the function? | |
Mar 14, 2021 at 14:58 | comment | added | user1822 |
Sure. That's why using format() is recommended.
|
|
Mar 14, 2021 at 14:43 | comment | added | Hedi Hadhri | Hi, thanks for your answer. I have another question: Could I call the function using a text as the table name instead of NULL::tablename ? I need to enter the name as string when I call the function but when I do it it says table does not exist. Thanks in advance. | |
Mar 13, 2021 at 18:34 | vote | accept | Hedi Hadhri | ||
Mar 13, 2021 at 9:16 | history | answered | user1822 | CC BY-SA 4.0 |