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

Поиск
Список
Период
Сортировка
От rloefgren@forethought.net
Тема Re: Proper escaping for char(3) string, or PHP at fault, or me at fault?
Дата
Msg-id 20070214070506.E20713@auden.jmla.com
обсуждение исходный текст
Ответ на Re: Proper escaping for char(3) string, or PHP at fault, or me at fault?  (Chris <dmagick@gmail.com>)
Ответы Re: Proper escaping for char(3) string, or PHP at fault, or me at fault?  (rloefgren@forethought.net)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: gayathri jayapal
Дата:
Сообщение: clarififcation
Следующее
От: "Andrus"
Дата:
Сообщение: Adding audit trail fields and triggers to all tables