missing FROM clause ?

[Zlatko Matić <zlatko.matic1@xxxxxxxxxxx>]

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