Query Formulation Question

Поиск
Список
Период
Сортировка
Искать
От
Тема
Query Formulation Question
Дата
в 19:30:34
Msg-id
20060512223021.46448.qmail@web33311.mail.mud.yahoo.com
Список
Дерево обсуждения
Query Formulation Question <operationsengineer1@yahoo.com>
Re: Query Formulation Question Sean Davis <sdavis2@mail.nih.gov>
Re: Query Formulation Question <operationsengineer1@yahoo.com>
Re: Query Formulation Question Sean Davis <sdavis2@mail.nih.gov>
consider the following simplified queries (php using
heredoc):

$sql_1 = <<<_EOSQL

select count(inspect)
from t_inspect, t_product, t_test_area 
where t_product.product_num = 1
and t_test_area.id = 5

_EOSQL

$sql_2 = <<<_EOSQL

select count(inspect)
from t_inspect, t_product, t_test_area 
where t_product.product_num = 1

_EOSQL

what is the best way to handle both of these cases in
one statement?

i know it would take the form of $sql_1, but what
value should i feed to t_test_area.id?  is there
syntax that will just ignore it or do i need to send a
value of 'NOT NULL'?  will NOT NULL slow down the
query when compared to $sql_2?

am i missing a better way to structure these queries?

as always, tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
В списке pgsql-novice по дате отправления
От: Tom Lane
Дата:
От: Sean Davis
Дата:
Сообщение: Re: Query Formulation Question
FAQ