Re: [ppa-users] [OT] ERROR: syntax error at or near "WHERE"

[Csanyi P. <csa...@gm...>]

Thu, 26 Jul 2012 01:42:29 -0500 -n
"Karl O. Pinc" <ko...@me...> írta:

> On 07/26/2012 12:12:11 AM, Csanyi Pal wrote:
> > Hi,
> > 
> > I have installed
> > PostgreSQL 9.1.4
> > phpPgAdmin 5.0.4
> > 
> > on my Debian GNU/Linux testing/sid system.
> > 
> > When in phpPgAdmin want to create a view then I get the error 
> > message:
> > (I'm using the Hungarian locale on my system.)
> > 
> > SQL hiba:
> > 
> > ERROR:  syntax error at or near "WHERE"
> > LINE 9:  WHERE felevek_kezdetei_1_8.felev1v2 = '2'
> >          ^
> > 
> > A következő kifejezésben:
> > 
> > CREATE VIEW "public"."a_2_felev_kezdete_vege_es_napok_szama" AS 
> > SELECT
> > 
> > felevek_kezdetei_1_8.datum AS "A 2. félév kezdete,",
> > TO_CHAR(felevek_kezdetei_1_8.datum, 'day') AS "az első nap,",
> > felev2_vege_tan_nap_1_7v8.datum AS "a félév vége,",
> > TO_CHAR(felev2_vege_tan_nap_1_7v8.datum) AS "az utolsó nap",
> > felev2_vege_tan_nap_1_7v8.ennyi_tan_nap AS "és a napok száma a
> > félévben", felev2_vege_tan_nap_1_7v8.oszt_1_7v8 AS "a következő
> > osztályoknak:" FROM felev2_vege_tan_nap_1_7v8 inner join
> > felevek_kezdetei_1_8 WHERE felevek_kezdetei_1_8.felev1v2 = '2'
> > 
> > What is the SQL syntacs error in this definition?
> 
> Your INNER JOIN has no ON clause?

Indeed, sorry.

> This is a bit offtopic, something this generic should
> be asked on the postgresql-user list.

Yes.

However I copy/paste here the solution and remove from it the 
phppgadmin's additions:

SELECT felevek_kezdetei_1_8.datum AS "A 2. félév kezdete,",
to_char(felevek_kezdetei_1_8.datum, 'tmday') AS "az első nap,", 
felev2_vege_tan_nap_1_7v8.datum AS "a félév vége,", 
to_char(felev2_vege_tan_nap_1_7v8.datum, 'tmday') AS "az utolsó nap",
felev2_vege_tan_nap_1_7v8.ennyi_tan_nap AS "összesen nap",
felev2_vege_tan_nap_1_7v8.oszt_1_7v8 AS "osztályoknak:" 
FROM felev2_vege_tan_nap_1_7v8 JOIN felevek_kezdetei_1_8 
ON felevek_kezdetei_1_8.felev1v2 = '2'
ORDER BY felev2_vege_tan_nap_1_7v8.datum

-- 
Regards from Pal