Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Richard HuxtonDate: 2005-10-27 11:17:06
Subject: Re: Why database is corrupted after re-booting
Previous:From: AndrusDate: 2005-10-27 10:53:15
Subject: Re: Why database is corrupted after re-booting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group