This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 185707 - Support Table Expressions
Summary: Support Table Expressions
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Mac OS X
: P3 normal (vote)
Assignee: Libor Fischmeistr
Depends on:
Reported: 2010-05-07 15:11 UTC by jdwyah
Modified: 2013-08-01 12:53 UTC (History)
0 users

See Also:
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description jdwyah 2010-05-07 15:11:34 UTC
I've become addicted to the table expressions available in Postgres 8.4:

When using them NetBeans SQL editor doesn't seem to be able to handle them. The autocomplete stops working or just suggests 'SELECT | DROP'. 

This is an example of the queries I've been writing. 

WITH latest_foo as
(select * from (select *, rank() over (PARTITION BY user_id order by date desc, id desc) from foo) ranked where rank = 1)

select severity, count(*) from latest_foo 
group by 1