| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | snpe <snpe(at)snpe(dot)co(dot)yu> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL JDBC and sub-select |
| Date: | 2002-11-09 19:07:17 |
| Message-ID: | 20021109110438.J29283-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
On Sat, 9 Nov 2002, snpe wrote:
> Hello,
> I work with JDeveloper and PostgreSQL JDBC and I have one problem.
> I get error :
> sub-SELECT in FORM must have an alias
> I can't change SQL command, but it is internal JDeveloper command
>
> Is it SQL standard (must have alias) or PostgreSQL specific ?
It looks to me to be standard.
I think the appropriate portion of the grammar is:
<table reference> :=
<derived table> [ AS ] <correlation name>
[ <left paren> <derived column list> <right paren> ]
<derived table> := <table subquery>
<correlation name> := <identifier>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | elein | 2002-11-09 21:16:32 | Re: Column based on pg-general |
| Previous Message | Neil Conway | 2002-11-09 18:56:33 | Re: Upgrade to dual processor machine? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-11-10 00:14:26 | Re: missing const it PQexscapeBytea/PQunescapeBytea in 7.3b3 |
| Previous Message | Stephan Szabo | 2002-11-09 19:03:05 | Re: Question about row visibility after locks |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aaron Mulder | 2002-11-10 03:19:51 | When Will This Happen? |
| Previous Message | snpe | 2002-11-09 17:51:41 | PostgreSQL JDBC and sub-select |