mdawlekar
Employee
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: PostgreSQL - Execute Snap
@chmurray88 I have used nested CTEs and I am still able to get the output results fields with inner_cte as ( select * from “all_data_types” where c_int <= 1000 limit 100) , outer_cte as (select * from inner_cte where c_int is not null limit 100 ) select * from outer_cte Please share us your Execute statement that you are using , So I can check and let you know.1.5KViews1like0CommentsRe: PostgreSQL - Execute Snap
Hi @chmurray88 To reply your question , yes Postgres Execute snap supports CTEs as part of a query. I took 2 CTEs and did a sample left join (both CTE is referring to same table with diff filter criteria) and the output result is as expected My SQL statement in Execute snap with cte as ( select * from “all_data_types” where c_int <= 1000 limit 100 ) , cte2 as (select * from “all_data_types” where c_int > 1000 limit 100 ) select * from cte left join cte2 on cte.c_smallint=cte2.c_smallint1.5KViews0likes2Comments