| From: | "DalTech - CTE" <CTE(at)Dal(dot)Ca> |
|---|---|
| To: | <poange(at)technologist(dot)com> |
| Cc: | "Pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: problem with view and case - please help |
| Date: | 2000-07-21 15:06:27 |
| Message-ID: | 00d201bff325$3ea36b60$5911be86@cte.Dal.Ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general pgsql-sql |
Instead of:
> WHEN $1 LIKE \'Mozilla/2.0 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape 2.0\'
> WHEN $1 LIKE \'Mozilla/2.02 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape 2.02\'
> WHEN $1 LIKE \'Mozilla/2.02E %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape 2.02E\'
> WHEN $1 LIKE \'Mozilla/3.0 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape 3.0\'
> WHEN $1 LIKE \'Mozilla/3.01 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape 3.01\'
> WHEN $1 LIKE \'Mozilla/3.02 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/3.03 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.0 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.03 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.04 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.05 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.06 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.07 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.08 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.5 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.51 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.6 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.61 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.7 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.71 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.72 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/4.73 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/5.0 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
> WHEN $1 LIKE \'Mozilla/6.0 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
> LIKE \'%compatible%\' THEN \'Netscape\'
Why not use:
WHEN $1 LIKE \'Mozilla/%\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT
LIKE \'%compatible%\' THEN \'Netscape\'
It should be true based on the rest of your function.
Cheers.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-23 05:57:40 | Re: Damn bug! |
| Previous Message | Tom Lane | 2000-07-21 14:44:22 | Re: postgres bug report |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Silesky Marketing Inc, Support | 2000-07-21 16:08:10 | password encryption |
| Previous Message | Ange Michel POZZO | 2000-07-21 14:41:06 | Re: [SQL] problem with view and case - please help |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-21 15:15:04 | Re: Timestamp indexes |
| Previous Message | Mitch Vincent | 2000-07-21 14:52:00 | Timestamp indexes |