missing FROM clause ? - Mailing list pgsql-general

From Zlatko Matić
Subject missing FROM clause ?
Date
Msg-id 001601c5dae6$fe02d960$6efa8353@zlatkovyfkpgz6
Whole thread Raw
Responses Re: missing FROM clause ?  (Richard Huxton <dev@archonet.com>)
List 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

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Why database is corrupted after re-booting
Next
From: Michael Fuhr
Date:
Subject: Re: Problem with SSL and postgreSQL 8.0.4