setting the where clause

Поиск
Список
Период
Сортировка
От johnf
Тема setting the where clause
Дата
Msg-id 200906100519.34171.jfabiani@yolo.com
обсуждение исходный текст
Ответы Re: setting the where clause  (Tom Lane <tgl@sss.pgh.pa.us>)
dynamic columns in a query  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
Список pgsql-sql
Hi,
I'm am programming in python using the Dabo modules.  www.dabodev.com if your 
interested.  Dabo is a framework that provides an easy way to build desktop 
app's.  To clear a data entry form. I have been setting the where clause 
to "where 1=0".  This of course retrieves 0 records and my form will display 
nothing.  It has been suggested that it might be better to set the where 
clause to a primary key value that does not exist in the table  "where PK 
= -9999999".   

I wonder what you guys think.  How might it effect performance?
-- 
John Fabiani


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

Предыдущее
От: Abbas
Дата:
Сообщение: Re: backup
Следующее
От: Tom Lane
Дата:
Сообщение: Re: setting the where clause