PostgreSQL - Execute Snap

[chmurray88]

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.

[darshthakkar]

That’s strange, can you please try a simple SELECT query and check if you’re getting any data in the output?

[chmurray88]

yes I get data out of a select snap… @Snaplogic …does the snap I’m asking about not support CTEs?

[darshthakkar]

Try a simple SELECT query on your EXECUTE snap, you should still get your data.

[chmurray88]

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.