Is NULLIF nullable?
| От | Dean Gibson (DB Administrator) |
|---|---|
| Тема | Is NULLIF nullable? |
| Дата | |
| Msg-id | 5.1.0.14.2.20041109192441.00ae3f68@imaps.mailpen.net обсуждение исходный текст |
| Ответ на | Re: JOIN performance (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Is NULLIF nullable?
|
| Список | pgsql-sql |
Recently I asked about why a field from the nullable side of an OUTER JOIN was causing the JOIN to be inefficient, and was told that it was because that field had a CASE statement as part of its definition, and that CASE (and by extension COALESCE) were non-nullable constructs. Is NULLIF nullable, in that sense? Reason: I'd like to define a VIEW with a field definition thusly: 'P.O. Box' || NULLIF( po_box, ' '::char ) AS ... And I would like the field thusly defined to be nullable. -- Dean
В списке pgsql-sql по дате отправления: