Quick Links

PostgreSQL JDBC and sub-select

From:	snpe <snpe(at)snpe(dot)co(dot)yu>
To:	<pgsql-hackers(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org, <pgsql-jdbc(at)postgresql(dot)org>
Subject:	PostgreSQL JDBC and sub-select
Date:	2002-11-09 17:51:41
Message-ID:	200211091751.41603.snpe@snpe.co.yu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-hackers pgsql-jdbc

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 ?

Regards
Haris Peco

Responses

Re: PostgreSQL JDBC and sub-select at 2002-11-09 19:07:17 from Stephan Szabo
Re: [HACKERS] PostgreSQL JDBC and sub-select at 2002-11-10 05:27:53 from Tom Lane
Re: [HACKERS] PostgreSQL JDBC and sub-select at 2002-11-10 08:51:08 from Hannu Krosing
SQL syntax (column alias) at 2002-11-10 15:41:54 from snpe

Browse pgsql-general by date

	From	Date	Subject
Next Message	Neil Conway	2002-11-09 18:56:33	Re: Upgrade to dual processor machine?
Previous Message	Jakub Ouhrabka	2002-11-09 16:59:41	Re: Mested select into the from of a a Select structure

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Stephan Szabo	2002-11-09 19:03:05	Re: Question about row visibility after locks
Previous Message	Peter Eisentraut	2002-11-09 16:32:45	Re: Beta 4

Browse pgsql-jdbc by date

	From	Date	Subject
Next Message	Stephan Szabo	2002-11-09 19:07:17	Re: PostgreSQL JDBC and sub-select
Previous Message	snpe	2002-11-08 22:21:57	Re: DatabaseMetaData.getTables problem