โ03-27-2023 01:29 PM
Does the PostgreSQL - Execute Snap not support using CTEโs as part of the query? When I try to include 1 or more CTEโs. all I get out of the snap is a status and message field returned, not the actual data.
โ03-28-2023 02:17 PM
Thatโs strange, can you please try a simple SELECT query and check if youโre getting any data in the output?
โ03-28-2023 02:28 PM - last edited on โ11-08-2023 05:07 PM by dmiller
yes I get data out of a select snapโฆ @Snaplogic โฆdoes the snap Iโm asking about not support CTEs?
โ03-28-2023 02:32 PM
Try a simple SELECT query on your EXECUTE snap, you should still get your data.
โ03-28-2023 02:45 PM - last edited on โ11-08-2023 05:07 PM by dmiller
thatโs not the pointโฆI want to have 1 or more CTEs building different sets of records and then select from that. this is basic query functionality. I want @Snaplogic to either ack they donโt support, show us how itโs supported, or see it on a roadmap.