Received: from agdal1.marwan.ac.ma ([194.204.246.130]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA91509 for ; Tue, 1 Jun 1999 11:31:07 -0400 (EDT) (envelope-from amarof@marwan.ac.ma) Received: from marwan.ac.ma (agdal2.marwan.ac.ma [194.204.246.131]) by agdal1.marwan.ac.ma (8.8.7/8.8.7) with ESMTP id PAA05204 for ; Tue, 1 Jun 1999 15:24:45 GMT Message-ID: <37594237.82D5D20E@marwan.ac.ma> Date: Sat, 05 Jun 1999 15:28:55 +0000 From: amarof X-Mailer: Mozilla 4.5 [fr] (Win95; I) X-Accept-Language: fr MIME-Version: 1.0 To: pgsql-general@postgreSQL.org Subject: ' syntax Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit i got your answers about the syntax, it works with the strings, but when etat takes a variable value, it gives a parser error. example : select * from table where field like $txt the error occurs when txt takes the value (doctortat d'etat). thanks