missing FROM clause ?

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: missing FROM clause ?
Date: 2005-10-27 11:08:07
Message-ID: 001601c5dae6$fe02d960$6efa8353@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.
In Postgres 8.1 I have a message that there is a missing FROM clause in the following query:

select into l_validity "rok_valjanosti"."rok_valjanosti" FROM ( SELECT min("rok_valjanosti"."rv_id") AS "rv_id", "rok_valjanosti"."rok_valjanosti" FROM "rok_valjanosti" GROUP BY "rok_valjanosti"."rv_id", "rok_valjanosti"."rok_valjanosti") sve;

If I change parameter "add missing from" in postgresl.conf to "on" than it works...
I would like to include FROM clause, but can't see where.

Thanks,

Zlatko

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-10-27 11:17:06 Re: Why database is corrupted after re-booting
Previous Message Andrus 2005-10-27 10:53:15 Re: Why database is corrupted after re-booting