Re: Proper escaping for char(3) string, or PHP at fault, or me at fault?

From: Chris <dmagick(at)gmail(dot)com>
To: semi-ambivalent <rloefgren(at)forethought(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Proper escaping for char(3) string, or PHP at fault, or me at fault?
Date: 2007-02-14 07:33:27
Message-ID: 45D2BB47.3050908@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-02-14 07:33:34 Re: backup database by cloning itself
Previous Message Ron Johnson 2007-02-14 07:29:23 Re: Union Query Improvement