Re: [JDBC] [HACKERS] PostgreSQL JDBC and sub-select

2002-11-14 Thread Christopher Kings-Lynne
> On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote: > > snpe kirjutas L, 09.11.2002 kell 22:51: > > > 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

Re: [JDBC] [HACKERS] PostgreSQL JDBC and sub-select

2002-11-14 Thread snpe
On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote: > snpe kirjutas L, 09.11.2002 kell 22:51: > > 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 J

Re: [JDBC] [HACKERS] PostgreSQL JDBC and sub-select

2002-11-10 Thread Nick Fankhauser
> > You could set up query logging in the backend and see what the offending > > query is. It may still be something you did (a missing or extra > > something somewhere). > > > How ? These settings have worked for me in a similar situation: (pulled from the admin list archives) My goal was to g

Re: [HACKERS] PostgreSQL JDBC and sub-select

2002-11-10 Thread snpe
On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote: > snpe kirjutas L, 09.11.2002 kell 22:51: > > 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 J

Re: [HACKERS] PostgreSQL JDBC and sub-select

2002-11-10 Thread snpe
On Sunday 10 November 2002 05:27 am, Tom Lane wrote: > snpe <[EMAIL PROTECTED]> writes: > > I work with JDeveloper and PostgreSQL JDBC and I have one problem. > > I get error : > > sub-SELECT in FORM must have an alias > > > > Is it SQL standard (must have alias) or PostgreSQL specific ? > > T

Re: [HACKERS] PostgreSQL JDBC and sub-select

2002-11-10 Thread Hannu Krosing
snpe kirjutas L, 09.11.2002 kell 22:51: > 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 You could set up query logging in the backend and s

Re: [HACKERS] PostgreSQL JDBC and sub-select

2002-11-09 Thread Tom Lane
snpe <[EMAIL PROTECTED]> writes: > I work with JDeveloper and PostgreSQL JDBC and I have one problem. > I get error : > sub-SELECT in FORM must have an alias > Is it SQL standard (must have alias) or PostgreSQL specific ? The SQL standard says you must write an alias. A FROM item is a (SQL

[HACKERS] PostgreSQL JDBC and sub-select

2002-11-09 Thread snpe
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 --