Re: IF ELSEIF Funktion in PL/pgSQL erstellen

Am Do, 19.12.2013, 19:30, schrieb Patryk Kordylewski:
> Hallo Gunnar,
Moinsen Jungs,

"warum einfach, wenn's auch umständlich geht".... oder habe ich irgendwas
grob übersehen / missverstanden?

>> ich habe einen View 'taxons' erstellt der (im wesentlichen) folgende
>> Daten erhält:
>>
>> family | genus | taxon_name
>> -------------+-------------+----------------------
>> SPHAERIIDAE | Pisidium | Pisidium personatum
>> SPHAERIIDAE | Pisidium | Pisidium sp.
>> SPHAERIIDAE | Sphaeriidae | Sphaeriidae Gen. sp.
>> (3 rows)
>>

>> Nun habe ich gelesen, dass ich mittels Funktionen Spalten gleich einem
>> View abspeichern kann.

bluthg=# create or replace view tax_view as (select *,
case when taxon_name ~ 'sp.$' then
case when genus ~ 'idae$' then 'Familie'
else 'Gattung'
end
else 'Art'
end
from taxons
);
CREATE VIEW
Zeit: 29,059 ms
bluthg=# SELECT * from tax_view ;
+-------------+-------------+----------------------+---------+
| family | genus | taxon_name | case |
+-------------+-------------+----------------------+---------+
| SPHAERIIDAE | Pisidium | Pisidium personatum | Art |
| SPHAERIIDAE | Pisidium | Pisidium sp. | Gattung |
| SPHAERIIDAE | Sphaeriidae | Sphaeriidae Gen. sp. | Familie |
+-------------+-------------+----------------------+---------+
(3 Zeilen)

Zeit: 0,435 ms
bluthg=#

Just my 2p,

Nick (as a matter of fact, auch Gunnar ;-)

>>
>> Ich hätte also gerne:
>>
>> SELECT *, taxon_level FROM taxons
>>
>> family | genus | taxon_name | taxon_level
>> -------------+-------------+----------------------+----------------
>> SPHAERIIDAE | Pisidium | Pisidium personatum | Art
>> SPHAERIIDAE | Pisidium | Pisidium sp. | Gattung
>> SPHAERIIDAE | Sphaeriidae | Sphaeriidae Gen. sp. | Familie
>> (3 rows)
>>

--
Gunnar "Nick" Bluth
RHCE/SCLA

Mobil +49 172 8853339
Email: gunnar(dot)bluth(at)pro-open(dot)de
__________________________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX. Ten years later
they are choosing Windows over UNIX. What part of that message aren't you
getting? - Tom Payne