On Thu, Jan 16, 2014 at 12:06 AM, Sam Mesh <Sam(dot)Mesh(at)gmail(dot)com> wrote:
> In my pgAdmin, F5 (execute query) works but F6 (execute pgScript) doesn't
> work:
>
> with T as (select * from TECHNICAL_DESCRIPTOR)select * from T;
>
> [ERROR ] 1.0: syntax error, unexpected character
Hmm, yeah - I guess the pgScript parser hasn't be taught that "WITH"
is now a valid SQL command. Dinesh, could you look into that please? I
guess it's just a case of adding WITH as a keyword.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company