Subquery Factoring / Common Table Expression / WITH clause

Last post 05-23-2012 9:58 AM by Linda84. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

05-23-2012 9:24 AM

JoshWithrow
Joined on 07-13-2009
Posts 11

Subquery Factoring / Common Table Expression / WITH clause

Reply Contact

It seems that Pervasive does not support this functionality... would I be correct in stating so? Just looking for clarification. WITH X AS (select * from table) or WITH (select * from table) AS X

05-23-2012 9:58 AM In reply to

Linda84
Joined on 07-10-2007
Posts 572

Re: Subquery Factoring / Common Table Expression / WITH clause

Reply Contact

PSQL does not support the WITH clause. You can use SELECT INTO to create a temporary table (local or global) and use it in other queries.

http://docs.pervasive.com/products/database/psqlv10/wwhelp/wwhimpl/js/html/wwhelp.htm#href=sqlref/syntaxref.4.70.html

Page 1 of 1 (2 items)