Re: Expression matching related question

Поиск
Список
Период
Сортировка
От Peter Hoskin
Тема Re: Expression matching related question
Дата
Msg-id 4439710F.8070609@criten.org
обсуждение исходный текст
Ответ на Expression matching related question  (Peter Hoskin <peterh@criten.org>)
Список pgsql-general
I should of mentioned, left is a bigint and network is an integer

Peter Hoskin wrote:
> Hi,
>
> I wish to do a query such as:
> SELECT * FROM table WHERE column='something' AND column2='something
> else' AND (network='0' OR (left=0 AND network>0));
>
> However, when I execute this in phppgadmin I'm told there is an error
> around the = character in left=0. Can't seem to figure the syntax.
>
> Help would be appreciated.
>
> Regards,
> Peter Hoskin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Date & Time with time zone
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Expression matching related question