Re: Proper escaping for char(3) string, or PHP at fault, or me at fault? - Mailing list pgsql-general

From Chris
Subject Re: Proper escaping for char(3) string, or PHP at fault, or me at fault?
Date
Msg-id 45D2BB47.3050908@gmail.com
Whole thread Raw
In response to Proper escaping for char(3) string, or PHP at fault, or me at fault?  ("semi-ambivalent" <rloefgren@forethought.net>)
Responses Re: Proper escaping for char(3) string, or PHP at fault, or me at fault?  (rloefgren@forethought.net)
List pgsql-general
semi-ambivalent wrote:
> All,
>
> I have a char(3) column that has occasional values of this:
> (V)
>
> In a PHP-called nested query I've a line something like:
> select * from tableA where  = any (select date from tableA where void !
> = '(V)') group by date order by record

Shouldn't that be

select * from table where FIELD = any (.....)

?

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: "Peter Eisentraut"
Date:
Subject: [ANNOUNCE] Advisory on possibly insecure security definer functions
Next
From: Ron Johnson
Date:
Subject: Re: backup database by cloning itself