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

From: rloefgren(at)forethought(dot)net
To: Chris <dmagick(at)gmail(dot)com>
Cc: semi-ambivalent <rloefgren(at)forethought(dot)net>, 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 14:08:00
Message-ID: 20070214070506.E20713@auden.jmla.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 14 Feb 2007, Chris wrote:

> 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/
>

Yes it should be, and I'm hoping I just made a typo in my post, but I've
missed bonehead mistakes like that in the past; it's not forbidden in the
future. I'll check after I take my son to school.

r

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-02-14 14:21:02 Re: suggestions on improving a query
Previous Message Rajarshi Guha 2007-02-14 13:22:42 Re: suggestions on improving a query